pgsql-sql  

Messages by Thread

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

• Earlier messages
• Later messages