pgsql-sql since 2011-03-02 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

March 2, 2011

Thread Author Time
Re: distinguishing identical columns after joins S G 13:45
Re: distinguishing identical columns after joins S G 14:24

March 7, 2011

Thread Author Time
A function to count all ocurrences of a character within a string. Piotr Czekalski 21:20
Re: A function to count all ocurrences of a character within a string. bricklen 22:08
Re: A function to count all ocurrences of a character within a string. Ross J. Reedstrom 22:32

March 9, 2011

Thread Author Time
How to transform table rows into Colum? Eric Ndengang 17:16
Re: How to transform table rows into Colum? Dmitriy Igrishin 18:07
plpgsql exception handling Uwe Bartels 21:55
Re: plpgsql exception handling Samuel Gendler 22:08

March 10, 2011

Thread Author Time
Re: plpgsql exception handling bricklen 00:20
Re: plpgsql exception handling Uwe Bartels 08:45
Re: plpgsql exception handling Uwe Bartels 08:45
Re: plpgsql exception handling Samuel Gendler 09:56
Re: plpgsql exception handling Uwe Bartels 10:53
Re: plpgsql exception handling Samuel Gendler 18:27
Re: plpgsql exception handling Uwe Bartels 18:38

March 17, 2011

Thread Author Time
Bizarreness at A2 Hosting Good, Thomas 16:26
Re: Bizarreness at A2 Hosting John DeSoi 17:05
Re: How to transform table rows into Colum? Richard Albright 17:12
Re: Bizarreness at A2 Hosting Good, Thomas 17:27

March 21, 2011

Thread Author Time
Obscure behavior of ORDER BY Tambet Matiisen 09:29

March 23, 2011

Thread Author Time
xml2 support Rob Sargent 16:52
xml2 support Rob Sargent 17:05
Re: xml2 support Serdar Gül 17:10
Re: xml2 support Rob Sargent 18:00
Re: xml2 support Serdar Gül 18:56
Re: Obscure behavior of ORDER BY Pavel Stehule 21:09
Re: converting big int to date Sree 21:12
pg_attributte, data types Viktor Bojović 23:05
Re: pg_attributte, data types Tom Lane 23:56

March 24, 2011

Thread Author Time
Re: xml2 support Isaac T. Dover 05:21
Re: pg_attributte, data types Viktor Bojović 07:49
Re: converting big int to date Vibhor Kumar 16:30

March 26, 2011

Thread Author Time
Re: converting big int to date Jasen Betts 10:04

March 27, 2011

Thread Author Time
Re: converting big int to date Jasen Betts 08:32

March 31, 2011

Thread Author Time
Aggregates puzzle 📎 Mark Fenbers 20:15
Re: Aggregates puzzle Ozer, Pam 23:14

April 5, 2011

Thread Author Time
is there a refactor John Fabiani 14:27
Re: is there a refactor Viktor Bojović 14:39
Re: is there a refactor Adrian Klaver 14:44
Re: is there a refactor Peter Steinheuser 14:49
Re: is there a refactor John Fabiani 14:58

April 8, 2011

Thread Author Time
Re: Aggregates puzzle msi77 10:21
Capture insert returning 14:18

April 12, 2011

Thread Author Time
pass in array to function for use by where clause? how optimize? Anish Kejariwal 17:08

April 13, 2011

Thread Author Time
unnesting of array of different size explodes memory Andreas Gaab 09:15
Re: unnesting of array of different size explodes memory Tom Lane 14:52
Re: pass in array to function for use by where clause? how optimize? Tom Lane 15:09
Re: pass in array to function for use by where clause? how optimize? Rob Sargent 15:48
Re: pass in array to function for use by where clause? how optimize? Tom Lane 16:15
Re: [SQL] unnesting of array of different size explodes memory Charlie 16:21
Re: pass in array to function for use by where clause? how optimize? Anish Kejariwal 19:03
strange update behavior Volkmar Herbst GCI 19:59

April 14, 2011

Thread Author Time
Get id of a tuple using exception f vf 10:56
Re: Get id of a tuple using exception Adrian Klaver 13:23
Re: Get id of a tuple using exception Adrian Klaver 14:32
update with recursive query Steven Dahlin 21:33
update using recursion Steven Dahlin 21:53

April 15, 2011

Thread Author Time
convert in GMT time zone without summer time LaraK 06:20
Re: update with recursive query Pavel Stehule 06:46

April 16, 2011

Thread Author Time
Re: convert in GMT time zone without summer time Jasen Betts 12:02
Re: Get id of a tuple using exception Jasen Betts 12:13

April 18, 2011

Thread Author Time
Re: convert in GMT time zone without summer time LaraK 07:10
Re: convert in GMT time zone without summer time Steve Crawford 16:56

April 20, 2011

Thread Author Time
[No subject] Humair Mohammed 14:45
How to realize ROW_NUMBER() in 8.3? Emi Lu 15:45
Re: How to realize ROW_NUMBER() in 8.3? Vibhor Kumar 16:06
Re: How to realize ROW_NUMBER() in 8.3? Oliveiros d'Azevedo Cristina 16:12
help on select Saulo Venâncio 20:10

April 21, 2011

Thread Author Time
Re: help on select Charlie 08:03
Re: Tom Lane 14:34
Re: help on select Jasen Betts 23:15

April 28, 2011

Thread Author Time
Select For Update and Left Outer Join Patrick Earl 06:00
[No subject] Ricardo Benatti 21:26

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

Browse Archives

Prev | Next