pgsql-sql

Messages by Date

2010/12/11 Re: [SQL] Correct usage of FOR UPDATE? Dmitriy Igrishin
2010/12/11 Re: [SQL] sqlplus reporting equivalent in postgres? Gary Chambers
2010/12/11 [SQL] concatenate question Tony Capobianco
2010/12/11 [SQL] Correct usage of FOR UPDATE? Joe Carr
2010/12/11 Re: [SQL] concatenate question Edgardo Portal
2010/12/11 Re: [SQL] The best option to insert data with primary id Jasen Betts
2010/12/10 Re: [SQL] sqlplus reporting equivalent in postgres? Samuel Gendler
2010/12/10 Re: [SQL] sqlplus reporting equivalent in postgres? Samuel Gendler
2010/12/10 Re: [SQL] sqlplus reporting equivalent in postgres? Igor Neyman
2010/12/09 [SQL] Fwd: Extended query protocol and exact types matches. Dmitriy Igrishin
2010/12/09 [SQL] sqlplus reporting equivalent in postgres? Tony Capobianco
2010/12/08 Re: [SQL] conditional aggregates Marcin Krawczyk
2010/12/08 Re: [SQL] concatenate question Tony Capobianco
2010/12/08 Re: [SQL] conditional aggregates Marc Mamin
2010/12/08 [SQL] Regular Expression Match Operator escape character Gnanakumar
2010/12/08 Re: [SQL] conditional aggregates Marcin Krawczyk
2010/12/08 Re: [SQL] conditional aggregates Pavel Stehule
2010/12/08 [SQL] conditional aggregates Marcin Krawczyk
2010/12/07 [SQL] mybatis 3 RETURNING id problem with insert. -
2010/12/07 Re: [SQL] concatenate question Peter Steinheuser
2010/12/07 Re: [SQL] concatenate question Richard Broersma
2010/12/07 Re: [SQL] concatenate question Kenneth Marshall
2010/12/07 Re: [SQL] concatenate question Dmitriy Igrishin
2010/12/07 Re: [SQL] concatenate question Peter Steinheuser
2010/12/07 Re: [SQL] concatenate question Tony Capobianco
2010/12/07 [SQL] concatenate question Tony Capobianco
2010/12/06 Re: [SQL] Union Question bricklen
2010/12/06 Re: [SQL] The best option to insert data with primary id mike
2010/12/06 Re: [SQL] The best option to insert data with primary id mike
2010/12/06 [SQL] The best option to insert data with primary id -
2010/12/06 [SQL] First aggregate with null support Marc Mamin
2010/12/05 Re: [SQL] Get the max viewd product_id for user_id Jayadevan M
2010/12/05 Re: [SQL] Get the max viewd product_id for user_id Mario Splivalo
2010/12/05 Re: [SQL] Get the max viewd product_id for user_id Mario Splivalo
2010/12/05 Re: [SQL] Get the max viewd product_id for user_id Mario Splivalo
2010/12/03 Re: [SQL] Union Question Jasen Betts
2010/12/03 [SQL] A note on how to generate a list of months within some period of time. Michał Roszka
2010/12/03 Re: [SQL] Union Question Shaun McCloud
2010/12/03 Re: [SQL] Union Question Christophe Pettus
2010/12/03 Re: [SQL] Union Question Shaun McCloud
2010/12/03 Re: [SQL] Union Question Christophe Pettus
2010/12/03 Re: [SQL] Union Question Plugge, Joe R.
2010/12/03 Re: [SQL] Union Question Shaun McCloud
2010/12/03 [SQL] Union Question Shaun McCloud
2010/12/03 Re: [SQL] COPY with FORMAT in Postgresql 9.x Tom Lane
2010/12/03 Re: [SQL] Get the max viewd product_id for user_id Jayadevan M
2010/12/03 [SQL] Get the max viewd product_id for user_id Mario Splivalo
2010/12/02 Re: [SQL] Calculate next event date based on instance of the day of week Jayadevan M
2010/12/02 [SQL] COPY with FORMAT in Postgresql 9.x Humair Mohammed
2010/12/02 [SQL] Calculate next event date based on instance of the day of week Dimitri
2010/12/01 Re: [SQL] DELETE WHERE EXISTS unexpected results Jasen Betts
2010/12/01 Re: [SQL] DELETE WHERE EXISTS unexpected results Jeff Bland
2010/12/01 Re: [SQL] How strings are sorted by LC_COLLATE specifically? Chang Chao
2010/12/01 Re: [SQL] OT - load a shp file John Fabiani
2010/12/01 Re: [SQL] DELETE WHERE EXISTS unexpected results Carla
2010/12/01 Re: [SQL] OT - load a shp file Lee Hachadoorian
2010/12/01 Re: [SQL] aggregation question Samuel Gendler
2010/11/30 [SQL] DELETE WHERE EXISTS unexpected results Jeff Bland
2010/11/30 [SQL] OT - load a shp file John Fabiani
2010/11/30 [SQL] aggregation question Samuel Gendler
2010/11/30 Re: [SQL] indexing longish string Isaac Dover
2010/11/30 Re: [SQL] How strings are sorted by LC_COLLATE specifically? Peter Eisentraut
2010/11/30 Re: [SQL] indexing longish string Isaac Dover
2010/11/30 Re: [SQL] indexing longish string Kenneth Marshall
2010/11/30 Re: [SQL] indexing longish string Rob Sargent
2010/11/30 Re: [SQL] indexing longish string jose
2010/11/30 [SQL] indexing longish string Rob Sargent
2010/11/30 Re: [SQL] Deleting entries from multiple tables manidegr8
2010/11/30 Re: [SQL] Is there a solution for "SELECT OR INSERT" Florian Weimer
2010/11/30 Re: [SQL] subselect and left join not working? Carla
2010/11/30 Re: [SQL] Deleting entries from multiple tables Achilleas Mantzios
2010/11/30 Re: [SQL] Deleting entries from multiple tables Dusan Misic
2010/11/30 Re: [SQL] Deleting entries from multiple tables Dusan Misic
2010/11/30 [SQL] Deleting entries from multiple tables manidegr8
2010/11/29 Re: [SQL] subselect and left join not working? Jorge Arenas
2010/11/29 Re: [SQL] subselect and left join not working? Tom Lane
2010/11/29 Re: [SQL] subselect and left join not working? Jasen Betts
2010/11/28 [SQL] Is there a solution for "SELECT OR INSERT" Stefan Becker
2010/11/28 [SQL] subselect and left join not working? Jorge Arenas
2010/11/27 Re: [SQL] atomic multi-threaded upsert Mikhail V. Puzanov
2010/11/26 Re: [SQL] Insert row in 1.10.1 and 1.10.3 ndias
2010/11/26 Re: [SQL] Insert row in 1.10.1 and 1.10.3 Guillaume Lelarge
2010/11/26 Re: [SQL] Insert row in 1.10.1 and 1.10.3 Thomas Kellerer
2010/11/26 Re: [SQL] Insert row in 1.10.1 and 1.10.3 ndias
2010/11/26 Re: [SQL] Insert row in 1.10.1 and 1.10.3 Oliveiros d'Azevedo Cristina
2010/11/26 Re: [SQL] group by hour + distinct Lew
2010/11/26 [SQL] Insert row in 1.10.1 and 1.10.3 ndias
2010/11/26 Re: [SQL] group by hour + distinct Oliveiros d'Azevedo Cristina
2010/11/26 Re: [SQL] group by hour + distinct Michele Petrazzo - Unipex
2010/11/26 Re: [SQL] group by hour + distinct Oliveiros d'Azevedo Cristina
2010/11/26 [SQL] group by hour + distinct Michele Petrazzo - Unipex
2010/11/25 Re: [SQL] error null value in column" concat_id" violates not-null constraint Pavel Stehule
2010/11/25 [SQL] error null value in column" concat_id" violates not-null constraint Ana Louro
2010/11/25 Re: [SQL] insert from a select Trinath Somanchi
2010/11/25 Re: [SQL] insert from a select John Fabiani
2010/11/25 Re: [SQL] insert from a select Carla
2010/11/25 Re: [SQL] insert from a select Carla
2010/11/24 Re: [SQL] atomic multi-threaded upsert MIkhail Puzanov
2010/11/24 Re: [SQL] atomic multi-threaded upsert MIkhail Puzanov
2010/11/24 Re: [SQL] atomic multi-threaded upsert KM
2010/11/24 [SQL] How strings are sorted by LC_COLLATE specifically? Chang Chao
2010/11/24 Re: [SQL] insert from a select Adrian Klaver
2010/11/24 [SQL] insert from a select John Fabiani
2010/11/24 Re: [SQL] atomic multi-threaded upsert Tom Lane
2010/11/24 Re: [SQL] "compressing" consecutive values into one Louis-David Mitterrand
2010/11/24 [SQL] atomic multi-threaded upsert Mikhail V. Puzanov
2010/11/23 Re: [SQL] "compressing" consecutive values into one bricklen
2010/11/23 Re: [SQL] "compressing" consecutive values into one Louis-David Mitterrand
2010/11/23 Re: [SQL] "compressing" consecutive values into one Oliveiros d'Azevedo Cristina
2010/11/23 [SQL] "compressing" consecutive values into one Louis-David Mitterrand
2010/11/22 Re: [SQL] Howto "insert or update" ? tv
2010/11/22 [SQL] Howto "insert or update" ? Andreas
2010/11/21 Re: [SQL] PostgreSQL array, recursion and more Dmitriy Igrishin
2010/11/19 Re: [SQL] force view column varchar(32) to varchar(128) Richard Broersma
2010/11/19 Re: [SQL] force view column varchar(32) to varchar(128) Andreas Kretschmer
2010/11/19 [SQL] force view column varchar(32) to varchar(128) Emi Lu
2010/11/18 Re: [SQL] obtaining difference between minimum value and next in size Oliveiros d'Azevedo Cristina
2010/11/17 Re: [SQL] obtaining difference between minimum value and next in size John Lister
2010/11/17 Re: [SQL] obtaining difference between minimum value and next in size Oliveiros d'Azevedo Cristina
2010/11/17 Re: [SQL] obtaining difference between minimum value and next in size Andreas Kretschmer
2010/11/17 Re: [SQL] obtaining difference between minimum value and next in size Tom Lane
2010/11/17 [SQL] obtaining difference between minimum value and next in size John Lister
2010/11/17 Re: [SQL] PostgreSQL array, recursion and more Achilleas Mantzios
2010/11/17 [SQL] PostgreSQL array, recursion and more Ferruccio Zamuner
2010/11/16 [SQL] Sum up network events by type, interval and network Axel Rau
2010/11/16 Re: [SQL] multi table import from 1 denormalized source table Jasen Betts
2010/11/15 [SQL] multi table import from 1 denormalized source table Andreas
2010/11/14 Re: [SQL] Need help with plpgsql function. Pavel Stehule
2010/11/14 Re: [SQL] Need help with plpgsql function. Adrian Klaver
2010/11/13 Re: [SQL] Need help with plpgsql function. Pavel Stehule
2010/11/13 [SQL] Need help with plpgsql function. berelith
2010/11/13 Re: [SQL] psql -f COPY from STDIN Tarlika Elisabeth Schmitz
2010/11/13 Re: [SQL] psql -f COPY from STDIN Tom Lane
2010/11/13 Re: [SQL] psql -f COPY from STDIN Tarlika Elisabeth Schmitz
2010/11/12 Re: [SQL] psql -f COPY from STDIN Tom Lane
2010/11/12 Re: [SQL] psql -f COPY from STDIN Adrian Klaver
2010/11/12 [SQL] psql -f COPY from STDIN Tarlika Elisabeth Schmitz
2010/11/12 Re: [SQL] Overlapping Ranges- Query Alternative Ozer, Pam
2010/11/12 Re: [SQL] "slow lock" log in addition to log_min_duration_statement ? Joshua Tolley
2010/11/12 Re: [SQL] Overlapping Ranges- Query Alternative Marc Mamin
2010/11/12 Re: [SQL] Overlapping Ranges- Query Alternative Andreas Gaab
2010/11/11 [SQL] Overlapping Ranges- Query Alternative Ozer, Pam
2010/11/10 [SQL] "slow lock" log in addition to log_min_duration_statement ? Bryce Nesbitt
2010/11/09 Re: [SQL] unexpected ORDER BY Tom Lane
2010/11/09 [SQL] unexpected ORDER BY Andreas
2010/11/07 [SQL] Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable Will Furnass
2010/11/04 Re: [SQL] I'm stuck - I just can't get this small FUNCT to run! Ralph Smith
2010/11/04 Re: [SQL] Trailing spaces - is there an easier way? Kenneth Marshall
2010/11/04 Re: [SQL] Trailing spaces - is there an easier way? Pavel Stehule
2010/11/04 [SQL] Trailing spaces - is there an easier way? Dean Gibson (DB Administrator)
2010/11/03 Re: [SQL] I'm stuck - I just can't get this small FUNCT to run! Tom Lane
2010/11/03 Re: [SQL] I'm stuck - I just can't get this small FUNCT to run! bricklen
2010/11/03 [SQL] I'm stuck - I just can't get this small FUNCT to run! Ralph Smith
2010/11/02 [SQL] problem with rules Uwe Bartels
2010/11/01 Re: [SQL] Sorting router interfaces Andreas
2010/11/01 Re: [SQL] Sorting router interfaces Filip Rembiałkowski
2010/11/01 [SQL] Sorting router interfaces Brian Sherwood
2010/10/31 Re: [SQL] large xml database Rob Sargent
2010/10/31 Re: [SQL] large xml database Viktor Bojović
2010/10/31 Re: [SQL] large xml database Rob Sargent
2010/10/31 Re: [SQL] large xml database Viktor Bojović
2010/10/31 Re: [SQL] large xml database Rob Sargent
2010/10/31 Re: [SQL] large xml database Viktor Bojović
2010/10/31 Re: [SQL] large xml database Viktor Bojović
2010/10/31 Re: [SQL] A more efficient way? Tom Lane
2010/10/31 [SQL] A more efficient way? James Cloos
2010/10/30 Re: [SQL] large xml database Lutz Steinborn
2010/10/30 Re: [SQL] large xml database James Cloos
2010/10/30 Re: [SQL] large xml database Rob Sargent
2010/10/30 Re: [SQL] large xml database Andreas Joseph Krogh
2010/10/30 [SQL] large xml database Viktor Bojović
2010/10/29 [SQL] Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable Will Furnass
2010/10/29 Re: [SQL] Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause Dmitriy Igrishin
2010/10/29 Re: [SQL] Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause Dmitriy Igrishin
2010/10/29 Re: [SQL] [GENERAL] How to update multiple rows Dann Corbit
2010/10/29 Re: [SQL] [GENERAL] How to update multiple rows Alban Hertroys
2010/10/29 [SQL] Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause Axel Rau
2010/10/28 Re: [SQL] How to Convert Integer to Serial venkat
2010/10/28 Re: [SQL] How to Convert Integer to Serial Shoaib Mir
2010/10/28 Re: [SQL] How to Convert Integer to Serial Shoaib Mir
2010/10/28 Re: [SQL] How to Convert Integer to Serial venkat
2010/10/28 [SQL] How to Convert Integer to Serial venkat
2010/10/26 [SQL] Different plan for one query problem Tatarnikov Alexander
2010/10/26 Re: [SQL] [GENERAL] How to update multiple rows venkat
2010/10/26 [SQL] How to update multiple rows venkat
2010/10/25 Re: [SQL] Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] Axel Rau
2010/10/25 Re: [SQL] Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] Sergey Konoplev
2010/10/25 Re: [SQL] Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] Richard Broersma
2010/10/25 [SQL] Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] Axel Rau
2010/10/25 Re: [SQL] How to search for a part of a number Harald Fuchs
2010/10/24 [SQL] How to search for a part of a number Andreas
2010/10/24 Re: [SQL] insert record in remote database Osvaldo Kussama
2010/10/23 Re: [SQL] insert record in remote database Osvaldo Kussama
2010/10/23 [SQL] insert record in remote database Maruti Nandan
2010/10/21 Re: [SQL] Need help on update. Nicholas I
2010/10/21 Re: [SQL] Need help on update. Richard Huxton
2010/10/21 [SQL] Need help on update. Nicholas I
2010/10/18 Re: [SQL] insert into table from list or array ? Andreas
2010/10/18 Re: [SQL] insert into table from list or array ? Pavel Stehule
2010/10/18 Re: [SQL] insert into table from list or array ? Viktor Bojović