pgsql-sql - May 2011

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 1, 2011

Thread	Author	Time
Multiple recursive part possible?	Svenne Krap	19:45
Re: Multiple recursive part possible?	Tom Lane	22:12

May 2, 2011

Thread	Author	Time
Re: Multiple recursive part possible?	Svenne Krap	03:18
BINARY and BINARY VARYING datatypes in PostgreSQL	Grzegorz Szpetkowski	10:46
getting PSQLException Can't infer the SQL type to use with Native Query call	Steven Dahlin	15:17
FATAL: invalid cache id: 19	manuel antonio ochoa	15:38
Re: FATAL: invalid cache id: 19	Tom Lane	16:25
Re: getting PSQLException Can't infer the SQL type to use with Native Query call	Tom Lane	16:30
PLpgSQL variables persistance between several functions calls	Charles N. Charotti	21:43

May 3, 2011

Thread	Author	Time
Re: [SQL] PLpgSQL variables persistance between several functions calls	Pavel Stehule	02:10
Re: convert in GMT time zone without summer time	LaraK	07:15
checking for the existence of a current_setting ?	Marc Mamin	08:07
Re: BINARY and BINARY VARYING datatypes in PostgreSQL	Susanne Ebrecht	09:12
Re: [SQL] PLpgSQL variables persistance between several functions calls	Willy-Bas Loos	10:20
Re: [SQL] PLpgSQL variables persistance between several functions calls	Viktor Bojović	11:01
Re: BINARY and BINARY VARYING datatypes in PostgreSQL	Grzegorz Szpetkowski	12:41
Re: How to realize ROW_NUMBER() in 8.3?	Emi Lu	14:53
Re: convert in GMT time zone without summer time	Steve Crawford	15:54
function timeout	Viktor Bojović	22:27

May 4, 2011

Thread	Author	Time
Re: How to realize ROW_NUMBER() in 8.3?	Andreas Kretschmer	05:28
data import via COPY, Rules + Triggers	Tarlika Elisabeth Schmitz	22:48

May 5, 2011

Thread	Author	Time
None numeric exclusion constraints using GIST	Richard Broersma	15:14
Re: data import via COPY, Rules + Triggers	Tarlika Elisabeth Schmitz	15:21
Select and merge rows?	Claudio Adriano Guarracino	20:18
Re: Select and merge rows?	Oliveiros	20:24
Select and merge rows?	Claudio Adriano Guarracino	20:53
Re: [SQL] Select and merge rows?	Charlie	21:41
slightly OT - Using psql from Emacs with sql.el	Seb	22:01
Re: slightly OT - Using psql from Emacs with sql.el	Rob Sargent	22:47
Re: slightly OT - Using psql from Emacs with sql.el	Seb	22:55
Re: slightly OT - Using psql from Emacs with sql.el	Rob Sargent	23:15

May 6, 2011

Thread	Author	Time
Re: Select and merge rows?	Claudio Adriano Guarracino	01:06
check constraint bug?	Tarlika Elisabeth Schmitz	05:06
Re: check constraint bug?	Scott Marlowe	05:10
Re: Select and merge rows?	Claudio Adriano Guarracino	05:41
None numeric exclusion constraints using GIST	Richard Broersma	14:57
FOR EACH STATEMENT trigger ?	Frédéric BROUARD	17:14
FOR EACH STATEMENT trigger ?	F. BROUARD / SQLpro	21:57
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

Browse Archives

Prev | Next