pgsql-sql before 2011-06-15 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

May 6, 2011

Thread	Author	Time
Re: FOR EACH STATEMENT trigger ?	Pavel Stehule	22:11

May 7, 2011

Thread	Author	Time
Re: data import via COPY, Rules + Triggers	Tarlika Elisabeth Schmitz	09:15
Re: data import via COPY, Rules + Triggers	Tarlika Elisabeth Schmitz	09:39
Specifying column level collations	Thomas Kellerer	11:19
Re: Specifying column level collations	Guillaume Lelarge	12:02
Re: Specifying column level collations	Thomas Kellerer	12:16
Re: check constraint bug?	Lew	12:52
Re: Specifying column level collations	Tom Lane	16:48
Re: Specifying column level collations	Thomas Kellerer	20:12
Re: slightly OT - Using psql from Emacs with sql.el	Seb	22:33

May 9, 2011

Thread	Author	Time
Re: FOR EACH STATEMENT trigger ?	Pavel Stehule	10:18
Trigger: update if record exists	Tarlika Elisabeth Schmitz	12:17
Sorting Issue	Ozer, Pam	16:25
Re: Sorting Issue	Emi Lu	19:37
Re: Sorting Issue	Ozer, Pam	19:39
Re: Sorting Issue	Emi Lu	19:52
Re: Sorting Issue	Ozer, Pam	19:52
Re: Sorting Issue	Emi Lu	20:38
Re: Sorting Issue	Samuel Gendler	21:08
Re: Sorting Issue	Tom Lane	21:28
Re: Sorting Issue	Ozer, Pam	22:13

May 10, 2011

Thread	Author	Time
view table with foreign key relative values	fpirotti	11:49
Re: Sorting Issue	Ozer, Pam	15:07
Re: Sorting Issue	Ozer, Pam	15:26
Re: Sorting Issue	Tom Lane	16:47
Dates and NULL's`	John Fabiani	16:48
Re: Sorting Issue	Edward W. Rouse	16:57
Re: Dates and NULL's`	Richard Broersma	17:16
Re: Dates and NULL's`	John Fabiani	17:24
Re: Dates and NULL's`	Richard Broersma	17:30
Re: Sorting Issue	Samuel Gendler	17:45
Re: Dates and NULL's`	John Fabiani	17:51
Re: Dates and NULL's`	Lew	17:55
Re: Sorting Issue	Scott Marlowe	17:56
Re: Dates and NULL's`	Emi Lu	20:16
Re: Dates and NULL's`	Brent Dombrowski	20:33
Re: Dates and NULL's`	Emi Lu	20:36
Re: Dates and NULL's`	Theodore Petrosky	20:51

May 11, 2011

Thread	Author	Time
replace " with nothing	Tony Capobianco	20:29
Re: replace " with nothing	Tony Capobianco	20:51
Re: replace " with nothing	Lew	20:53
Re: replace " with nothing	Leif Biberg Kristensen	21:11
Re: replace " with nothing	Ross J. Reedstrom	21:22
Re: replace " with nothing	Ross J. Reedstrom	21:25
Re: replace " with nothing	Leif Biberg Kristensen	21:37
CROSS JOIN ordering	Grzegorz Szpetkowski	23:19

May 12, 2011

Thread	Author	Time
ordering by date for each ID	Nguyen,Diep T	01:59
Re: CROSS JOIN ordering	Richard Huxton	11:01
Re: ordering by date for each ID	Thomas Kellerer	20:45
Re: ordering by date for each ID	Samuel Gendler	22:18

May 13, 2011

Thread	Author	Time
Sorting data based fields in two linked tables	R. Smith	15:00

May 14, 2011

Thread	Author	Time
Re: Sorting data based fields in two linked tables	Oliver d'Azevedo Christina	12:58
Re: [SQL] Sorting data based fields in two linked tables	Charlie	13:54
self join	Seb	22:09
Re: self join	Ian Lawrence Barwick	22:39
Re: self join	Seb	22:49

May 15, 2011

Thread	Author	Time
Re: self join	Jasen Betts	02:36
Re: self join	Harald Fuchs	08:04

May 16, 2011

Thread	Author	Time
Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	10:05
Re: Performance of NOT IN and <> with PG 9.0.4	Craig Ringer	11:06
Re: self join	Steve Crawford	15:50
Which version of PostgreSQL should I use.	Gavin Baumanis	23:04

May 17, 2011

Thread	Author	Time
Re: self join	Jasen Betts	09:07

May 18, 2011

Thread	Author	Time
enum data type vs table	Seb	04:23
foreign keys and lots of tables	Gary Stainburn	19:10
column type for pdf file	Emi Lu	20:20
Re: column type for pdf file 📎	Julien Cigar	20:46
client-side lo_import() provided by libpq ?	Emi Lu	20:51
Re: column type for pdf file	Karsten Hilbert	21:00
Re: column type for pdf file 📎	Julien Cigar	21:21
Re: column type for pdf file	Karsten Hilbert	21:27
Re: column type for pdf file 📎	Julien Cigar	21:37
Re: Sorting Issue	Ozer, Pam	22:22
Re: column type for pdf file	Eric McKeeth	23:06

May 19, 2011

Thread	Author	Time
Re: foreign keys and lots of tables	David W Noon	00:09
Re: client-side lo_import() provided by libpq ?	Craig Ringer	02:02
Re: column type for pdf file	Craig Ringer	02:15
Re: column type for pdf file	Piotr Czekalski	06:00
Re: SOLVED - foreign keys and lots of tables	Gary Stainburn	08:38
Re: column type for pdf file	Emi Lu	13:39
Re: column type for pdf file	Karsten Hilbert	13:53
Re: column type for pdf file	Craig Ringer	14:29
Re: column type for pdf file	Emi Lu	17:48

May 20, 2011

Thread	Author	Time
unnest in SELECT	Karl Koster	19:13
unnest in SELECT	Karl Koster	19:45

May 21, 2011

Thread	Author	Time
Re: unnest in SELECT	Andreas Kretschmer	06:58
Re: Which version of PostgreSQL should I use.	Gavin Baumanis	23:10
Re: Which version of PostgreSQL should I use.	Basil Bourque	23:45

May 22, 2011

Thread	Author	Time
Re: unnest in SELECT	Craig Ringer	03:23
extracting location info from string	Tarlika Elisabeth Schmitz	20:05
Re: extracting location info from string	Tarlika Elisabeth Schmitz	22:00

May 23, 2011

Thread	Author	Time
Re: extracting location info from string	Andrej	01:11
Re: extracting location info from string	Craig Ringer	01:42
Re: extracting location info from string	Lew	04:25
Re: extracting location info from string	Edward W. Rouse	15:17
Re: Which version of PostgreSQL should I use.	jasmin.dizdarevic	15:19
Re: extracting location info from string	Tarlika Elisabeth Schmitz	15:33
problem with update data sets from front ends 8.4, Ubuntu 10.04	Dean le Roux	16:53
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Samuel Gendler	18:01
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Dean le Roux	21:22
Re: extracting location info from string	Tarlika Elisabeth Schmitz	22:39
Re: Which version of PostgreSQL should I use.	Craig Ringer	23:18

May 24, 2011

Thread	Author	Time
Re: extracting location info from string	Craig Ringer	00:59
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Adrian Klaver	01:04
Re: Which version of PostgreSQL should I use.	Craig Ringer	06:48
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	10:49
Re: Which version of PostgreSQL should I use.	Jasmin Dizdarevic	10:58
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	11:45
Re: extracting location info from string	Lew	16:57
Re: Performance of NOT IN and <> with PG 9.0.4	Robert Haas	19:14
Problems Pgdump	manuel antonio ochoa	19:22
Re: Problems Pgdump	manuel antonio ochoa	19:26
Re: Performance of NOT IN and <> with PG 9.0.4	Robert Haas	19:49
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	21:10

May 25, 2011

Thread	Author	Time
Re: Which version of PostgreSQL should I use.	Craig Ringer	01:56
Re: Problems Pgdump	Craig Ringer	02:07
Re: Performance of NOT IN and <> with PG 9.0.4	Tom Lane	14:13
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	15:23
Re: extracting location info from string	Rob Sargent	15:25
Re: extracting location info from string	Tarlika Elisabeth Schmitz	18:14
Re: Performance of NOT IN and <> with PG 9.0.4	Robert Haas	19:49
Re: extracting location info from string	Tarlika Elisabeth Schmitz	21:13
Re: [SQL] extracting location info from string	Charlie	22:06
Re: extracting location info from string	Rob Sargent	22:07
Re: extracting location info from string	Andrej	22:15
Re: Sorting Issue	Ozer, Pam	22:18
Re: enum data type vs table	Peter Koczan	22:23
Re: enum data type vs table	Seb	23:08

May 26, 2011

Thread	Author	Time
Re: column type for pdf file	Ross J. Reedstrom	18:07
copy record?	Gauthier, Dave	20:23
Re: extracting location info from string	Tarlika Elisabeth Schmitz	20:40
Re: copy record?	Gauthier, Dave	21:04
Re: copy record?	Bosco Rama	21:18

May 27, 2011

Thread	Author	Time
Re: copy record?	Jasen Betts	04:45
Re: copy record?	Merlin Moncure	15:39
500KB PDF files for postgresql8.3, which is the most efficient way?	Emi Lu	16:12
Re: 500KB PDF files for postgresql8.3, which is the most efficient way?	Emi Lu	16:15
Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way?	Samuel Gendler	19:28
Order of evaluation in triggers for checks on inherited table partitions	Kevin Crain	19:28
Re: Order of evaluation in triggers for checks on inherited table partitions	Tarlika Elisabeth Schmitz	19:52

May 28, 2011

Thread	Author	Time
Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way?	Piotr Czekalski	07:58
Function to total reset a schema	Surfing	14:16

May 29, 2011

Thread	Author	Time
Function to total reset a schema	Surfing	07:38
Re: Function to total reset a schema	Scott Marlowe	07:49
Re: Function to total reset a schema	Thomas Kellerer	07:54
Re: Function to total reset a schema	Surfing	08:03

May 30, 2011

Thread	Author	Time
Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way?	Enrico Weigelt	07:39
Re: Order of evaluation in triggers for checks on inherited table partitions	Jasen Betts	09:21
Re: Function to total reset a schema	Rob Sargent	14:45

May 31, 2011

Thread	Author	Time
Re: Re: Order of evaluation in triggers for checks on inherited table partitions	Kevin Crain	13:40
Re: Re: Order of evaluation in triggers for checks on inherited table partitions	Kevin Crain	14:46

June 1, 2011

Thread	Author	Time
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Dean le Roux	15:00
9.0+ way of determining if a LISTEN channel has a backend listening?	James Robinson	15:51
Re: 9.0+ way of determining if a LISTEN channel has a backend listening?	Greg Sabino Mullane	22:22

June 3, 2011

Thread	Author	Time
selecting records X minutes apart	lists-pgsql	19:52

June 4, 2011

Thread	Author	Time
Re: selecting records X minutes apart	Kevin Crain	01:01
Re: selecting records X minutes apart	Jasen Betts	11:45
Re: selecting records X minutes apart	Kevin Crain	15:49
Re: selecting records X minutes apart	lists-pgsql	18:58
Re: selecting records X minutes apart	lists-pgsql	19:15
Re: selecting records X minutes apart	Richard Broersma	20:09
Re: [SQL] selecting records X minutes apart	Charlie	20:42
Re: selecting records X minutes apart	lists-pgsql	20:49

June 5, 2011

Thread	Author	Time
Re: selecting records X minutes apart	Kevin Crain	00:51
Re: selecting records X minutes apart	Kevin Crain	00:56
Re: selecting records X minutes apart	lists-pgsql	01:36
Re: selecting records X minutes apart	Richard Broersma	02:10
Re: [SQL] selecting records X minutes apart	Charlie	04:02
Re: selecting records X minutes apart	Masaru Sugawara	11:52
Re: selecting records X minutes apart	Masaru Sugawara	12:06
Re: selecting records X minutes apart	lists-pgsql	19:42

June 6, 2011

Thread	Author	Time
To find process that lock a table	manuel antonio ochoa	23:16
Re: To find process that lock a table	Scott Marlowe	23:21

June 9, 2011

Thread	Author	Time
need help with some aggregation magic	Andreas	13:43
Re: need help with some aggregation magic	Oliveiros d'Azevedo Cristina	14:16
Re: need help with some aggregation magic	Andreas	16:13
Re: need help with some aggregation magic	Richard Broersma	16:20
Re: need help with some aggregation magic	Andreas	16:55
Re: need help with some aggregation magic	Edgardo Portal	21:22
Re: need help with some aggregation magic	Kevin Crain	21:39

June 10, 2011

Thread	Author	Time
ANY for Array value check	Emi Lu	15:10

June 11, 2011

Thread	Author	Time
Returning a set of dates	C. Bensend	04:28
Re: Returning a set of dates	Samuel Gendler	05:11
Re: ANY for Array value check	Jasen Betts	09:59
Subselects not allowed?	Leif Biberg Kristensen	15:01
Re: Subselects not allowed?	Guillaume Lelarge	15:08
Re: Subselects not allowed?	Tom Lane	15:14
Re: Subselects not allowed?	Andreas Kretschmer	15:23
Re: Subselects not allowed?	Leif Biberg Kristensen	15:23
Re: Subselects not allowed?	Leif Biberg Kristensen	15:39
Re: Subselects not allowed?	Leif Biberg Kristensen	20:09
Re: Returning a set of dates	C. Bensend	22:18

June 12, 2011

Thread	Author	Time
Re: Subselects not allowed?	Leif Biberg Kristensen	08:22
Re: Subselects not allowed?	Andreas Kretschmer	08:37
Re: selecting records X minutes apart	Gavin Flower	21:50

June 13, 2011

Thread	Author	Time
extract some column/value pairs via hstore	Tarlika Elisabeth Schmitz	19:04

June 14, 2011

Thread	Author	Time
Storage of Indian Language text in postgresql through PHP	INDER	07:17
Re: Subselects not allowed?	Florian Weimer	14:00
Sqlite to postgres database conversion.swedish chararacter issue	sara vanan	17:37
Re: Storage of Indian Language text in postgresql through PHP	Amitabh Kant	20:14

Browse Archives

Prev | Next