Messages by Date
-
2011/05/03
[SQL] checking for the existence of a current_setting ?
Marc Mamin
-
2011/05/02
Re: [SQL] PLpgSQL variables persistance between several functions calls
Pavel Stehule
-
2011/05/02
[SQL] PLpgSQL variables persistance between several functions calls
Charles N. Charotti
-
2011/05/02
Re: [SQL] getting PSQLException Can't infer the SQL type to use with Native Query call
Tom Lane
-
2011/05/02
Re: [SQL] FATAL: invalid cache id: 19
Tom Lane
-
2011/05/02
[SQL] FATAL: invalid cache id: 19
manuel antonio ochoa
-
2011/05/02
[SQL] getting PSQLException Can't infer the SQL type to use with Native Query call
Steven Dahlin
-
2011/05/02
[SQL] BINARY and BINARY VARYING datatypes in PostgreSQL
Grzegorz Szpetkowski
-
2011/05/01
Re: [SQL] Multiple recursive part possible?
Svenne Krap
-
2011/05/01
Re: [SQL] Multiple recursive part possible?
Tom Lane
-
2011/05/01
[SQL] Multiple recursive part possible?
Svenne Krap
-
2011/04/28
[SQL]
Ricardo Benatti
-
2011/04/27
[SQL] Select For Update and Left Outer Join
Patrick Earl
-
2011/04/21
Re: [SQL] help on select
Jasen Betts
-
2011/04/21
Re: [SQL]
Tom Lane
-
2011/04/21
Re: [SQL] help on select
Charlie
-
2011/04/20
[SQL] help on select
Saulo Venâncio
-
2011/04/20
[SQL]
Humair Mohammed
-
2011/04/20
Re: [SQL] How to realize ROW_NUMBER() in 8.3?
Oliveiros d'Azevedo Cristina
-
2011/04/20
Re: [SQL] How to realize ROW_NUMBER() in 8.3?
Vibhor Kumar
-
2011/04/20
[SQL] How to realize ROW_NUMBER() in 8.3?
Emi Lu
-
2011/04/18
Re: [SQL] convert in GMT time zone without summer time
Steve Crawford
-
2011/04/18
Re: [SQL] convert in GMT time zone without summer time
LaraK
-
2011/04/16
Re: [SQL] Get id of a tuple using exception
Jasen Betts
-
2011/04/16
Re: [SQL] convert in GMT time zone without summer time
Jasen Betts
-
2011/04/14
Re: [SQL] update with recursive query
Pavel Stehule
-
2011/04/14
[SQL] convert in GMT time zone without summer time
LaraK
-
2011/04/14
[SQL] update with recursive query
Steven Dahlin
-
2011/04/14
[SQL] update using recursion
Steven Dahlin
-
2011/04/14
Re: [SQL] Get id of a tuple using exception
Adrian Klaver
-
2011/04/14
Re: [SQL] Get id of a tuple using exception
Adrian Klaver
-
2011/04/14
[SQL] Get id of a tuple using exception
f vf
-
2011/04/13
[SQL] strange update behavior
Volkmar Herbst GCI
-
2011/04/13
Re: [SQL] pass in array to function for use by where clause? how optimize?
Anish Kejariwal
-
2011/04/13
[SQL] Re: [SQL] unnesting of array of different size explodes memory
Charlie
-
2011/04/13
Re: [SQL] pass in array to function for use by where clause? how optimize?
Tom Lane
-
2011/04/13
Re: [SQL] pass in array to function for use by where clause? how optimize?
Rob Sargent
-
2011/04/13
Re: [SQL] pass in array to function for use by where clause? how optimize?
Tom Lane
-
2011/04/13
Re: [SQL] unnesting of array of different size explodes memory
Tom Lane
-
2011/04/13
[SQL] unnesting of array of different size explodes memory
Andreas Gaab
-
2011/04/12
[SQL] pass in array to function for use by where clause? how optimize?
Anish Kejariwal
-
2011/04/08
[SQL] Capture insert returning
scorpdaddy
-
2011/04/08
Re: [SQL] Aggregates puzzle
msi77
-
2011/04/05
Re: [SQL] is there a refactor
John Fabiani
-
2011/04/05
Re: [SQL] is there a refactor
Peter Steinheuser
-
2011/04/05
Re: [SQL] is there a refactor
Adrian Klaver
-
2011/04/05
Re: [SQL] is there a refactor
Viktor Bojović
-
2011/04/05
[SQL] is there a refactor
John Fabiani
-
2011/03/31
Re: [SQL] Aggregates puzzle
Ozer, Pam
-
2011/03/31
[SQL] Aggregates puzzle
Mark Fenbers
-
2011/03/27
Re: [SQL] converting big int to date
Jasen Betts
-
2011/03/26
Re: [SQL] converting big int to date
Jasen Betts
-
2011/03/24
Re: [SQL] converting big int to date
Vibhor Kumar
-
2011/03/24
Re: [SQL] converting big int to date
Sree
-
2011/03/24
Re: [SQL] pg_attributte, data types
Viktor Bojović
-
2011/03/23
Re: [SQL] xml2 support
Isaac T. Dover
-
2011/03/23
Re: [SQL] pg_attributte, data types
Tom Lane
-
2011/03/23
[SQL] pg_attributte, data types
Viktor Bojović
-
2011/03/23
Re: [SQL] Obscure behavior of ORDER BY
Pavel Stehule
-
2011/03/23
[SQL] xml2 support
Rob Sargent
-
2011/03/23
[SQL] Obscure behavior of ORDER BY
Tambet Matiisen
-
2011/03/23
Re: [SQL] xml2 support
Serdar Gül
-
2011/03/23
Re: [SQL] xml2 support
Rob Sargent
-
2011/03/23
Re: [SQL] xml2 support
Serdar Gül
-
2011/03/23
[SQL] xml2 support
Rob Sargent
-
2011/03/17
Re: [SQL] Bizarreness at A2 Hosting
Good, Thomas
-
2011/03/17
Re: [SQL]How to transform table rows into Colum?
Richard Albright
-
2011/03/17
Re: [SQL] Bizarreness at A2 Hosting
John DeSoi
-
2011/03/17
[SQL] Bizarreness at A2 Hosting
Good, Thomas
-
2011/03/10
Re: [SQL] plpgsql exception handling
Uwe Bartels
-
2011/03/10
Re: [SQL] plpgsql exception handling
Samuel Gendler
-
2011/03/10
Re: [SQL] plpgsql exception handling
Uwe Bartels
-
2011/03/10
Re: [SQL] plpgsql exception handling
Samuel Gendler
-
2011/03/10
Re: [SQL] plpgsql exception handling
Uwe Bartels
-
2011/03/10
Re: [SQL] plpgsql exception handling
Uwe Bartels
-
2011/03/09
Re: [SQL] plpgsql exception handling
bricklen
-
2011/03/09
Re: [SQL] plpgsql exception handling
Samuel Gendler
-
2011/03/09
[SQL] plpgsql exception handling
Uwe Bartels
-
2011/03/09
Re: [SQL]How to transform table rows into Colum?
Dmitriy Igrishin
-
2011/03/09
[SQL]How to transform table rows into Colum?
Eric Ndengang
-
2011/03/07
Re: [SQL] A function to count all ocurrences of a character within a string.
Ross J. Reedstrom
-
2011/03/07
Re: [SQL] A function to count all ocurrences of a character within a string.
bricklen
-
2011/03/07
[SQL] A function to count all ocurrences of a character within a string.
Piotr Czekalski
-
2011/03/02
Re: [SQL] distinguishing identical columns after joins
S G
-
2011/03/02
Re: [SQL] distinguishing identical columns after joins
S G
-
2011/03/01
Re: [SQL] distinguishing identical columns after joins
Lee Hachadoorian
-
2011/03/01
Re: [SQL] distinguishing identical columns after joins
Stephen Cook
-
2011/03/01
Re: [SQL] distinguishing identical columns after joins
Rob Sargent
-
2011/03/01
Re: [SQL] distinguishing identical columns after joins
S G
-
2011/03/01
Re: [SQL] Problem with serial counters
Richard Huxton
-
2011/03/01
Re: [SQL] distinguishing identical columns after joins
Rob Sargent
-
2011/03/01
[SQL] distinguishing identical columns after joins
S G
-
2011/02/28
Re: [SQL] what's wrong in this procedure?
Vibhor Kumar
-
2011/02/25
Re: [SQL] what's wrong in this procedure?
Rob Sargent
-
2011/02/25
Re: [SQL] Problem with serial counters
Vibhor Kumar
-
2011/02/25
Re: [SQL] what's wrong in this procedure?
Yeb Havinga
-
2011/02/25
Re: [SQL] what's wrong in this procedure?
Adrian Klaver
-
2011/02/25
[SQL] what's wrong in this procedure?
Camaleon
-
2011/02/25
[SQL] Problem with serial counters
Jacques Lebrun
-
2011/02/24
Re: [SQL] Compare two Data bases Structure
Isaac Dover
-
2011/02/24
Re: [SQL] Compare two Data bases Structure
Isaac Dover
-
2011/02/24
Re: [SQL] Compare two Data bases Structure
Vibhor Kumar
-
2011/02/24
Re: [SQL] Compare two Data bases Structure
Piotr Czekalski
-
2011/02/23
Re: [SQL] Function To Strip HTML
Ozer, Pam
-
2011/02/23
Re: [SQL] Compare two Data bases Structure
Plugge, Joe R.
-
2011/02/23
[SQL] Compare two Data bases Structure
manuel antonio ochoa
-
2011/02/23
[SQL] Function To Strip HTML
Ozer, Pam
-
2011/02/23
Re: [SQL] quotes etc
Emi Lu
-
2011/02/22
Re: [SQL] quotes etc
Adrian Klaver
-
2011/02/22
Re: [SQL] quotes etc
Kenneth Marshall
-
2011/02/22
[SQL] quotes etc
John Fabiani
-
2011/02/22
[SQL] Re: Retrieve the column values of a record without knowing the names
arthur_info
-
2011/02/22
Re: [SQL] replace_matches does not return {null}
Tom Lane
-
2011/02/22
[SQL] replace_matches does not return {null}
Andreas Gaab
-
2011/02/21
Re: [SQL] Is it possible to get DISTINCT rows from RETURNING clause?
Gnanakumar
-
2011/02/19
Re: [SQL] Determine length of numeric field
Jasen Betts
-
2011/02/19
Re: [SQL] Is it possible to get DISTINCT rows from RETURNING clause?
Dmitriy Igrishin
-
2011/02/19
Re: [SQL] Retrieve the column values of a record without knowing the names
Dmitriy Igrishin
-
2011/02/18
[SQL] Re: Retrieve the column values of a record without knowing the names
arthur_info
-
2011/02/18
[SQL] Re: Retrieve the column values of a record without knowing the names
arthur_info
-
2011/02/18
[SQL] Re: Retrieve the column values of a record without knowing the names
arthur_info
-
2011/02/18
Re: [SQL] Retrieve the column values of a record without knowing the names
Achilleas Mantzios
-
2011/02/18
Re: [SQL] Retrieve the column values of a record without knowing the names
Pavel Stehule
-
2011/02/17
[SQL] Retrieve the column values of a record without knowing the names
arthur_info
-
2011/02/17
Re: [SQL] Is it possible to get DISTINCT rows from RETURNING clause?
Gnanakumar
-
2011/02/17
Re: [SQL] Function compile error
Sivannarayanreddy
-
2011/02/17
Re: [SQL] ARRAY_AGG and COUNT
bricklen
-
2011/02/17
Re: [SQL] ARRAY_AGG and COUNT
Andreas Forø Tollefsen
-
2011/02/17
Re: [SQL] ARRAY_AGG and COUNT
bricklen
-
2011/02/17
Re: [SQL] After insert trigger and select
Igor Neyman
-
2011/02/17
[SQL] ARRAY_AGG and COUNT
Andreas Forø Tollefsen
-
2011/02/16
[SQL] Is it possible to get DISTINCT rows from RETURNING clause?
Gnanakumar
-
2011/02/16
Re: [SQL] After insert trigger and select
Rok Jaklič
-
2011/02/16
Re: [SQL] After insert trigger and select
pasman pasmański
-
2011/02/16
Re: [SQL] Oracle Equivalent queries in Postgres
bricklen
-
2011/02/16
[SQL] After insert trigger and select
Rok Jaklič
-
2011/02/16
Re: [SQL] Function compile error
Igor Neyman
-
2011/02/16
[SQL] Retrieve the column values of a record without knowing the names
arthur_info
-
2011/02/16
Re: [SQL] Oracle Equivalent queries in Postgres
Tom Lane
-
2011/02/16
Re: [SQL] Function compile error
Pavel Stehule
-
2011/02/16
[SQL] Function compile error
Sivannarayanreddy
-
2011/02/16
Re: [SQL] Oracle Equivalent queries in Postgres
Thomas Kellerer
-
2011/02/16
Re: [SQL] Oracle Equivalent queries in Postgres
Pavel Stehule
-
2011/02/16
Re: [SQL] Oracle Equivalent queries in Postgres
Pavel Stehule
-
2011/02/16
Re: [SQL] Oracle Equivalent queries in Postgres
Thomas Kellerer
-
2011/02/16
Re: [SQL] Oracle Equivalent queries in Postgres
Pavel Stehule
-
2011/02/16
[SQL] Oracle Equivalent queries in Postgres
Sivannarayanreddy
-
2011/02/16
Re: [SQL] PL/SQL block error
Pavel Stehule
-
2011/02/16
[SQL] PL/SQL block error
Sivannarayanreddy
-
2011/02/15
[SQL] recommended data model for a search?
Mark Stosberg
-
2011/02/15
Re: [SQL] Determine length of numeric field
Tony Capobianco
-
2011/02/15
Re: [SQL] Determine length of numeric field
Tom Lane
-
2011/02/15
Re: [SQL] Determine length of numeric field
Tony Capobianco
-
2011/02/15
Re: [SQL] Determine length of numeric field
Peter Steinheuser
-
2011/02/15
Re: [SQL] Determine length of numeric field
Pavel Stehule
-
2011/02/15
[SQL] Determine length of numeric field
Tony Capobianco
-
2011/02/14
Re: [SQL] SQL gotcha
Achilleas Mantzios
-
2011/02/14
[SQL] SQL gotcha
Dean Gibson (DB Administrator)
-
2011/02/13
Re: [SQL] UTF characters compromising data import.
Gavin Beau Baumanis
-
2011/02/12
Re: [SQL] UTF characters compromising data import.
Jasen Betts
-
2011/02/12
Re: [SQL] DELETE FROM takes forever
Jasen Betts
-
2011/02/11
Re: [SQL] Drawing a blank on some SQL
Samuel Gendler
-
2011/02/11
Re: [SQL] Drawing a blank on some SQL
Aaron Burnett
-
2011/02/11
Re: [SQL] Drawing a blank on some SQL
Osvaldo Kussama
-
2011/02/11
Re: [SQL] Drawing a blank on some SQL
Samuel Gendler
-
2011/02/11
Re: [SQL] Drawing a blank on some SQL
Rob Sargent
-
2011/02/11
Re: [SQL] Drawing a blank on some SQL
Peter Steinheuser
-
2011/02/11
[SQL] Drawing a blank on some SQL
Aaron Burnett
-
2011/02/11
Re: [SQL] DELETE FROM takes forever
Hiltibidal, Rob
-
2011/02/10
Re: [SQL] DELETE FROM takes forever
Chris Browne
-
2011/02/10
Re: [SQL] DELETE FROM takes forever
Josh
-
2011/02/10
Re: [SQL] DELETE FROM takes forever
Piotr Czekalski
-
2011/02/10
Re: [SQL] DELETE FROM takes forever
Tom Lane
-
2011/02/10
Re: [SQL] DELETE FROM takes forever
Samuel Gendler
-
2011/02/10
[SQL] DELETE FROM takes forever
Josh
-
2011/02/08
Re: [SQL] data import: 12-hour time w/o AM/PM
Tarlika Elisabeth Schmitz
-
2011/02/08
Re: [SQL] data import: 12-hour time w/o AM/PM
Tarlika Elisabeth Schmitz
-
2011/02/08
Re: [SQL] "select c1, method(c2) group by c1" returns all values of c2 for c1
Pavel Stehule
-
2011/02/08
Re: [SQL] "select c1, method(c2) group by c1" returns all values of c2 for c1
Emi Lu
-
2011/02/08
Re: [SQL] "select c1, method(c2) group by c1" returns all values of c2 for c1
Peter Steinheuser
-
2011/02/08
Re: [SQL] "select c1, method(c2) group by c1" returns all values of c2 for c1
Rolando Edwards
-
2011/02/08
Re: [SQL] "select c1, method(c2) group by c1" returns all values of c2 for c1
Pavel Stehule
-
2011/02/08
[SQL] "select c1, method(c2) group by c1" returns all values of c2 for c1
Emi Lu
-
2011/02/08
Re: [SQL] data import: 12-hour time w/o AM/PM
Andrej
-
2011/02/08
Re: [SQL] data import: 12-hour time w/o AM/PM
Leif Biberg Kristensen
-
2011/02/08
Re: [SQL] data import: 12-hour time w/o AM/PM
Oliveiros d'Azevedo Cristina
-
2011/02/08
[SQL] data import: 12-hour time w/o AM/PM
Tarlika Elisabeth Schmitz
-
2011/02/08
Re: [SQL] Cumulative result with increment
Shawn Tayler
-
2011/02/08
Re: [SQL] Get postgresql server ip address
Chris Browne
-
2011/02/08
Re: [SQL] Get postgresql server ip address
Dmitriy Igrishin
-
2011/02/08
[SQL] Get postgresql server ip address
Gera Mel Handumon
-
2011/02/08
Re: [SQL] UTF characters compromising data import.
Pavel Stehule
-
2011/02/08
[SQL] UTF characters compromising data import.
Gavin Beau Baumanis
-
2011/02/07
Re: [SQL] why SELECT query needs relationname (schemaName.tableName)
Samuel Gendler
-
2011/02/07
[SQL] why SELECT query needs relationname (schemaName.tableName)
Amar Dhole
-
2011/02/07
Re: [SQL] Cumulative result with increment
Steve Crawford
-
2011/02/07
[SQL] Cumulative result with increment
Shawn Tayler
-
2011/02/06
Re: [SQL] PosgreSQL - TSQL2 question
Craig Ringer
-
2011/02/06
[SQL] PosgreSQL - TSQL2 question
Sarbu Anca
-
2011/02/06
Re: [SQL] TABLE PARTITION
Vibhor Kumar