comp.databases.postgresql.sql

create unique index schema.index_name on table (column)?

Started on 11 September 2004 22:42
Last reply by m0ntar3 on 12 September 2004 22:33
[ Posts: 4 ] [ Views: 601 ]

Re: HOW TO HANDLE ZEROS IN DATE FIELD?

Started on 11 September 2004 14:57
Last reply by grzm on 11 September 2004 14:57
[ Posts: 0 ] [ Views: 436 ]

Using UPDATE FROM

Started on 09 September 2004 21:54
Last reply by tgl on 11 September 2004 08:17
[ Posts: 1 ] [ Views: 563 ]

Re: HOW TO HANDLE ZEROS IN DATE FIELD?

Started on 11 September 2004 07:44
Last reply by grzm on 11 September 2004 07:44
[ Posts: 0 ] [ Views: 476 ]

aggregate function stddev

Started on 08 September 2004 23:11
Last reply by pgman on 10 September 2004 23:48
[ Posts: 2 ] [ Views: 716 ]

Isnumeric function?

Started on 07 September 2004 07:44
Last reply by gsstark on 10 September 2004 17:33
[ Posts: 22 ] [ Views: 4132 ]

Datetime conversion in WHERE clause

Started on 09 September 2004 16:23
Last reply by Josh on 09 September 2004 20:42
[ Posts: 1 ] [ Views: 640 ]

Query Plan

Started on 09 September 2004 07:30
Last reply by dev on 09 September 2004 10:28
[ Posts: 1 ] [ Views: 647 ]

check for circular references in a 2-table heirachy

Started on 09 September 2004 03:43
Last reply by terencek on 09 September 2004 03:43
[ Posts: 0 ] [ Views: 630 ]

Temporary solution around inheritance/foreign key problem.

Started on 09 September 2004 03:30
Last reply by Vadim.Passynkov on 09 September 2004 03:30
[ Posts: 0 ] [ Views: 623 ]

Temporary solution around inheritance/fireign key problem.

Started on 09 September 2004 02:22
Last reply by Vadim.Passynkov on 09 September 2004 02:22
[ Posts: 0 ] [ Views: 609 ]

SQL99 "with recursive" question

Started on 08 September 2004 01:38
Last reply by Thomas Wegner on 08 September 2004 01:38
[ Posts: 0 ] [ Views: 1286 ]

Problem with returning setof record

Started on 07 September 2004 19:13
Last reply by dev on 07 September 2004 19:35
[ Posts: 1 ] [ Views: 4126 ]

Problem with LATIN1 characters from Perl-DBI

Started on 07 September 2004 14:06
Last reply by andreak on 07 September 2004 15:53
[ Posts: 1 ] [ Views: 9337 ]

When a table was last ANALYZEd

Started on 06 September 2004 22:30
Last reply by troels on 06 September 2004 22:30
[ Posts: 0 ] [ Views: 1616 ]

Storing properties in a logical way.

Started on 06 September 2004 05:42
Last reply by xt on 06 September 2004 21:37
[ Posts: 2 ] [ Views: 622 ]

How to rename a constraint/trigger??

Started on 06 September 2004 16:03
Last reply by klodoma on 06 September 2004 16:03
[ Posts: 0 ] [ Views: 565 ]

Full access to a DB with a second user?

Started on 05 September 2004 14:53
Last reply by Olly on 06 September 2004 08:24
[ Posts: 1 ] [ Views: 532 ]

INFORMATION_SCHEMA and foreign keys

Started on 06 September 2004 00:56
Last reply by tgl on 06 September 2004 04:13
[ Posts: 3 ] [ Views: 3554 ]

Scary Porn

Started on 05 September 2004 13:43
Last reply by james001 on 05 September 2004 13:43
[ Posts: 0 ] [ Views: 3210 ]

Re: PRIMARY KEY and INDEX

Started on 02 September 2004 16:48
Last reply by devrim on 02 September 2004 16:48
[ Posts: 0 ] [ Views: 589 ]

Complicated "group by" question

Started on 25 August 2004 19:04
Last reply by Jeff Boes on 02 September 2004 16:39
[ Posts: 4 ] [ Views: 819 ]

copy old column's values to new column

Started on 02 September 2004 15:16
Last reply by Bruno on 02 September 2004 15:51
[ Posts: 1 ] [ Views: 635 ]

Re: PRIMARY KEY and INDEX

Started on 02 September 2004 15:50
Last reply by achill on 02 September 2004 15:50
[ Posts: 0 ] [ Views: 772 ]

Defining Field Types with view

Started on 01 September 2004 22:27
Last reply by tgl on 02 September 2004 00:41
[ Posts: 1 ] [ Views: 584 ]

Extracting fieldnames from a TABLE

Started on 01 September 2004 17:14
Last reply by tfo on 01 September 2004 18:28
[ Posts: 1 ] [ Views: 708 ]

colored PL with emacs

Started on 31 August 2004 13:42
Last reply by JD on 01 September 2004 17:57
[ Posts: 6 ] [ Views: 714 ]

German "umlaut insensitive" query

Started on 01 September 2004 16:01
Last reply by Robert on 01 September 2004 17:17
[ Posts: 2 ] [ Views: 862 ]

casting BOOL to somthng

Started on 31 August 2004 11:06
Last reply by sszabo on 01 September 2004 16:33
[ Posts: 18 ] [ Views: 1223 ]

German "umlaut insensitive" query

Started on 01 September 2004 11:51
Last reply by Robert on 01 September 2004 11:51
[ Posts: 0 ] [ Views: 626 ]

Arbitrary precision arithmatic with pgsql

Started on 31 August 2004 13:55
Last reply by JanWieck on 31 August 2004 17:12
[ Posts: 8 ] [ Views: 651 ]

proberm with rule

Started on 26 August 2004 02:15
Last reply by bmay2068 on 31 August 2004 16:47
[ Posts: 1 ] [ Views: 635 ]

specifying type int date intervals

Started on 31 August 2004 16:19
Last reply by teknokrat on 31 August 2004 16:19
[ Posts: 0 ] [ Views: 603 ]

function fails where individual statements succeed

Started on 30 August 2004 19:17
Last reply by rosser.schwarz on 31 August 2004 00:12
[ Posts: 6 ] [ Views: 604 ]

Re: expression_tree_walker: Unexpected node type 711

Started on 29 August 2004 18:26
Last reply by tgl on 29 August 2004 18:26
[ Posts: 0 ] [ Views: 561 ]

backup of a specific schema

Started on 27 August 2004 07:51
Last reply by mendola on 29 August 2004 13:20
[ Posts: 6 ] [ Views: 3697 ]

Aggregate query for multiple records

Started on 26 August 2004 08:23
Last reply by scott on 28 August 2004 20:08
[ Posts: 7 ] [ Views: 620 ]

from PG_DUMP to CVS

Started on 26 August 2004 12:04
Last reply by pjw on 28 August 2004 18:10
[ Posts: 13 ] [ Views: 618 ]

Re: [PERFORM] Why those queries do not utilize indexes?

Started on 27 August 2004 23:33
Last reply by igorart7 on 27 August 2004 23:33
[ Posts: 0 ] [ Views: 739 ]

Copy command freezes but INSERT works fine with trigger on insert.

Started on 27 August 2004 22:16
Last reply by igorart7 on 27 August 2004 22:53
[ Posts: 1 ] [ Views: 569 ]