Mailing lists [pgsql-sql]
- Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier
- Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Owen Jacobson
- Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Tom Lane
- queries problems Joÿffffffffffe3o Carvalho
- Re: queries problems Michael Fuhr
- Re: queries problems Michael Fuhr
- Last access date for databases/users Marc McIntyre
- Returning with the inserted id Graf László
- Re: Returning with the inserted id Richard Huxton
-
cursor "
" already in use Stathis Stergou -
Re: cursor "
" already in use Michael Fuhr - not sure about constraints Jerome Alet
- Re: not sure about constraints Achilleus Mantzios
- Re: not sure about constraints Jerome Alet
- Turn off auto-commit Joÿffffffffffe3o Carvalho
- Re: Turn off auto-commit Owen Jacobson
- Recommendation on bytea or blob for binary data like images leon@oss.minimetria.com
- Re: Recommendation on bytea or blob for binary data like images Tom Lane
- Re: insert only if conditions are met? Henry Ortega
- Re: insert only if conditions are met? Philip Hallstrom
- Searching for results with an unknown amount of data Oz
- Re: Negative lookbehind assertions in regexs Julian Scarfe
- Re: Negative lookbehind assertions in regexs Alvaro Herrera
- Re: Negative lookbehind assertions in regexs Dawid Kuroczko
- joining two simular (but not identical tables) Neil Dugan
- Re: joining two simular (but not identical tables) Michael Fuhr
- Help with UNION query Andreas Joseph Krogh
- Re: Help with UNION query Andreas Joseph Krogh
- Re: Help with UNION query Andreas Joseph Krogh
- POSIX Regular Expression question Aldor
- Re: POSIX Regular Expression question A. Kretschmer
- Re: POSIX Regular Expression question Michael Fuhr
- Re: POSIX Regular Expression question Peter Eisentraut
- Re: POSIX Regular Expression question A. Kretschmer
- Re: POSIX Regular Expression question Alvaro Herrera
- Re: POSIX Regular Expression question Peter Eisentraut
- Re: POSIX Regular Expression question Harald Fuchs
- Re: POSIX Regular Expression question Peter Eisentraut
- Re: POSIX Regular Expression question Peter Eisentraut
- Re: POSIX Regular Expression question Tom Lane
- Equivalent of Oracle SQL%NOTFOUND in plpgsql Bath, David
- Re: Equivalent of Oracle SQL%NOTFOUND in plpgsql Tom Lane
- Weird Trigger Behaviour using IF ... THEN ... ESLEIF... THEN... ELSEIF... THEN ... ELSE ... END IF; Antony Sohal
- Searching for results with an unknown amount of data DownLoad X
- Table Constraint CHECK(SELECT()) alternative? Robert D. Kennedy
- SQL queries Joÿffffffffffe3o Carvalho
- ERROR: syntax error at or near "select" at character 9 Graf László
- Re: [GENERAL] How do I copy part of table from db1 to db2 (and rename the columns)? Roman Neuhauser
- Re: [GENERAL] How do I copy part of table from db1 to db2 (and Tino Wildenhain
- Re: insert only if conditions are met? Chris Travers
- Re: sql function: using set as argument Akshay Mathur
- Performance issue Ricky Sutanto
- Re: Table Constraint CHECK(SELECT()) alternative? Stephan Szabo
- Re: Table Constraint CHECK(SELECT()) alternative? Dinesh Pandey
- Re: Weird Trigger Behaviour using IF ... THEN ... ESLEIF... Stephan Szabo
- Re: ERROR: syntax error at or near "select" at character 9 Stephan Szabo
- Re: Searching for results with an unknown amount of data Thomas F. O'Connell
- Re: ERROR: syntax error at or near "select" at character 9 Harald Fuchs
- Re: ERROR: syntax error at or near "select" at character 9 Stephan Szabo
- Re: Searching for results with an unknown amount of data Bruno Wolff III
- Re: Help with UNION query Bruno Wolff III
- Re: POSIX Regular Expression question Bruno Wolff III
- Re: Recommendation on bytea or blob for binary data like images Leon Torres
- Statistics from Sequences Joÿffffffffffe3o Carvalho
- Re: Statistics from Sequences Michael Fuhr
- Re: Statistics from Sequences Bruno Wolff III
- AGE function Louise Catherine
- Re: AGE function Michael Fuhr
- Re: AGE function Louise Catherine
- Re: AGE function A. Kretschmer
- Re: AGE function Michael Fuhr
- Re: AGE function Tom Lane
- Re: AGE function Michael Fuhr
- Help with multistage query Rick Schumeyer
- Re: uuid type (moved from HACKERS) Josh Berkus
- Re: Help with multistage query Russell Simpkins
- column names, types, properties for a table Roger Tannous
- Re: column names, types, properties for a table Philip Hallstrom
- Re: Help with multistage query Matt Emmerton
- Re: Searching for results with an unknown amount of data DownLoad X
- Re: column names, types, properties for a table Roger Tannous
- Re: uuid type (moved from HACKERS) Greg Stark
- Indexing an array? Silke Trissl
- Re: Indexing an array? Josh Berkus
- Re: Indexing an array? Dmitri Bichko
- Re: Indexing an array? Tom Lane
- Re: Statistics from Sequences Michael Fuhr
- Re: column names, types, properties for a table thomas.silvi
- Re: Statistics from Sequences Joÿffffffffffe3o Carvalho
- a "catch all" type ... such a thing? Marc G. Fournier
- how to replace Michael Höller
- Re: how to replace Owen Jacobson
- Re: how to replace Anthony Molinaro
- Re: Statistics from Sequences Michael Fuhr
- Re: queries problems Joÿffffffffffe3o Carvalho
- Re: queries problems Michael Fuhr
- Re: queries problems Tom Lane
- Numeric Columns miwalsh
- Re: Numeric Columns Tom Lane
- Re: how to replace A. Kretschmer
- Re: a "catch all" type ... such a thing? Eugene E.
- Re: a "catch all" type ... such a thing? Michael Glaesemann
- SELECT: retrieve only 2 rows next to known row Nikolay Samokhvalov
- Re: SELECT: retrieve only 2 rows next to known row Bruno Wolff III
- Re: SELECT: retrieve only 2 rows next to known row Tom Lane
- how to have 2 select creteria on one column? Michael Hoeller
- Re: how to have 2 select creteria on one column? Richard Huxton
- how to update with a join? Michael Hoeller
- Fwd: how to have 2 select creteria on one column? SOLVED Michael Hoeller
- Re: how to update with a join? MichaelHoeller@t-online.de
- Re: how to have 2 select creteria on one column? Bruno Wolff III
- Re: how to update with a join? Bruno Wolff III
- Re: a "catch all" type ... such a thing? Peter Eisentraut
- Re: a "catch all" type ... such a thing? Trent Shipley
- Need help with 'unique parents' constraint Leif B. Kristensen
- Re: Need help with 'unique parents' constraint Leif B. Kristensen
- Re: Need help with 'unique parents' constraint Greg Sabino Mullane
- Panic: Page Add Item: Corrupted page pointers The One
- Re: Need help with 'unique parents' constraint John Hasler
- Re: Panic: PageAddItem: Corrupted page pointers The One
- showing multiple reference details from single query Ferindo Middleton Jr
- Re: showing multiple reference details from single query Michael Fuhr
- Re: Panic: PageAddItem: Corrupted page pointers Alvaro Herrera
- Re: Panic: Page Add Item: Corrupted page pointers Tom Lane
- howto insert dynamic value liofr
- Re: howto insert dynamic value Michael Fuhr
- Re: howto insert dynamic value wendell
- Please help, can't figure out what's wrong with this function... Moritz Bayer
- Re: Please help, can't figure out what's wrong with this function... John DeSoi
- Re: Please help, can't figure out what's wrong with this function... Tom Lane
- refer a column as a varible name? gherzig@fmed.uba.ar
- Re: Need help with 'unique parents' constraint Leif B. Kristensen
- Re: refer a column as a varible name? Michael Fuhr
- Re: Need help with `unique parents` constraint Greg Sabino Mullane
- How do I convert an integet to a timestamp? Wei
- Re: Indexing an array? Ron Mayer
- user defined type, plpgsql function and NULL Bjoern A. Zeeb
- Age in days Mark A. Strivens
- Re: Performance issue tgoodair@ca.afilias.info (Tim Goodaire)
- Re: Age in days Gnanavel S
- Re: Age in days Michael Glaesemann
- Re: user defined type, plpgsql function and NULL Tom Lane
- Re: How do I convert an integet to a timestamp? Michael Fuhr
- Re: How do I convert an integet to a timestamp? Eugene E.
- Re: SELECT: retrieve only 2 rows next to known row Marcin Piotr Grondecki
- Re: refer a column as a varible name? gherzig@fmed.uba.ar
- What should this query match? Joost Kraaijeveld
- Re: What should this query match? Peter Eisentraut
- Re: What should this query match? Joost Kraaijeveld
- Re: Need help with 'unique parents' constraint Daryl Richter
- Re: What should this query match? Peter Eisentraut
- CREATE TEMPORARY TABLE ON COMMIT DROP Luis Sousa
- Re: CREATE TEMPORARY TABLE ON COMMIT DROP Tom Lane
- showing multiple REFERENCE details of id fields in single query that share the same table Ferindo Middleton Jr
- Re: showing multiple REFERENCE details of id fields in single query that share the same table Thomas O'Connell
- Triggers & Conditional Assignment Neil Saunders
- Re: Triggers & Conditional Assignment Gnanavel S
- Re: showing multiple REFERENCE details of id fields in single Daryl Richter
- Re: Triggers & Conditional Assignment Tom Lane
- passing values into .sql scripts Geoffrey Knauth
- How to install Postgresql 8 on different drive letter? The One
- Re: passing values into .sql scripts Michael Fuhr
- Re: passing values into .sql scripts Geoffrey Knauth
- Re: showing multiple REFERENCE details of id fields in single Daryl Richter
- alter sequence + subqueries jeff sacksteder
- plpgsql function not accepting NULL value Kenneth Dombrowski
- Re: plpgsql function not accepting NULL value Stephan Szabo
- Re: alter sequence + subqueries Alvaro Herrera
- Re: plpgsql function not accepting NULL value Michael Fuhr
- Re: plpgsql function not accepting NULL value Kenneth Dombrowski
- Re: alter sequence + subqueries Michael Fuhr
- Re: How to install Postgresql 8 on different drive letter? Magnus Hagander
- unsuscribe Nicolas Cornu
- Inheritance (general hints wanted) Achilleus Mantzios
- Re: Inheritance (general hints wanted) thomas.silvi
- Re: Inheritance (general hints wanted) Achilleus Mantzios
- Re: Inheritance (general hints wanted) Achilleus Mantzios
- How to add column from old_table to new_table? Joost Kraaijeveld
- Re: How to add column from old_table to new_table? Joost Kraaijeveld
- Re: How to add column from old_table to new_table? A. Kretschmer
- Re: How to add column from old_table to new_table? Thomas Pundt
- Re: How to add column from old_table to new_table? Gnanavel S
- Re: How to add column from old_table to new_table? Leif B. Kristensen
- Re: How to add column from old_table to new_table? Joost Kraaijeveld
- Re: How to add column from old_table to new_table? Gnanavel S
- Re: How to add column from old_table to new_table? A. Kretschmer
- R-tree and start/end queries Sean Davis
- Re: R-tree and start/end queries Bruno Wolff III
- Re: R-tree and start/end queries Chris Mungall
- Re: R-tree and start/end queries Dmitri Bichko
- Re: R-tree and start/end queries Tom Lane
- delete item[5] from varchar[] array??? Matthew Peter
- Re: delete item[5] from varchar[] array??? Michael Fuhr
- Re: delete item[5] from varchar[] array??? Tom Lane
- Re: delete item[5] from varchar[] array??? Matthew Peter
- Copy Views From Database? lennie@corepat.com
- Re: Copy Views From Database? Hannes Dorbath
-
cancel
- Re: Copy Views From Database? Hannes Dorbath
- Updating cidr column with network operator Axel Rau
- Re: Copy Views From Database? Hannes Dorbath
- postgres on the comman line Michael Höller
- Re: postgres on the comman line Thomas Pundt
- Re: postgres on the comman line A. Kretschmer
- Re: postgres on the comman line Achilleus Mantzios
- Re: Updating cidr column with network operator Daryl Richter
- Using descriptor areas to insert andy rost
- Help with a view Leif B. Kristensen
- Re: Updating cidr column with network operator Axel Rau
- Re: Help with a view Dmitri Bichko
- Re: Help with a view Leif B. Kristensen
- Re: Updating cidr column with network operator Daryl Richter
- Issue with UPDATE statement on v8 Kenneth Hutchinson
- Re: Help with a view Rajesh Kumar Mallah
- Re: Issue with UPDATE statement on v8 Tom Lane
- Re: Issue with UPDATE statement on v8 Rajesh Kumar Mallah
- Re: Help with a view Dmitri Bichko
- Re: Using descriptor areas to insert Josh Berkus
- Primary and Foreign Key? Announce
- Re: Primary and Foreign Key? Russell Simpkins
- Functions, transactions and RETURN Stewart Ben (RBAU/EQS4) *
- Difficulties with a master-detail query Milen A. Radev
- Issue with UPDATE statement on v8 Kenneth Hutchinson
- Re: Functions, transactions and RETURN Stewart Ben (RBAU/EQS4) *
- Re: Issue with UPDATE statement on v8 Michael Fuhr
- Where are user defined functions stored? Hilary Forbes
- Re: Difficulties with a master-detail query Bruno Wolff III
- Re: Where are user defined functions stored? Tom Lane
- Re: [ADMIN] COPY TO / COPY FROM Aldor
- Re: Where are user defined functions stored? Hilary Forbes
- Re: Where are user defined functions stored? Tom Lane
- Re: Updating cidr column with network operator Axel Rau
- Re: delete item[5] from varchar[] array??? Matthew Peter
- Re: Updating cidr column with network operator Michael Fuhr
- Re: Updating cidr column with network operator Daryl Richter
- Re: delete item[5] from varchar[] array??? Michael Fuhr
- Re: Updating cidr column with network operator Axel Rau
- Re: Updating cidr column with network operator Axel Rau
- Re: delete item[5] from varchar[] array??? Matthew Peter
- VACUUM FULL vs dump & restore Ilya A. Kovalenko
- Re: VACUUM FULL vs dump & restore Aldor
- Re: VACUUM FULL vs dump & restore Aldor
- stored procs in postgresql ceremona@gmail.com
- Re: stored procs in postgresql Chris Browne
- redundancy in CHECK CONSTRAINTs Ferindo Middleton Jr
- Re: redundancy in CHECK CONSTRAINTs Tom Lane
- Re: stored procs in postgresql Cere Davis
- Re: redundancy in CHECK CONSTRAINTs Ferindo Middleton Jr
- Re: stored procs in postgresql A. Kretschmer
- Re: Updating cidr column with network operator Michael Fuhr
- Re: Updating cidr column with network operator Axel Rau
- Re: Possible to delete record from all tables at the same time? Chris Browne
- add column if doesn't exist Brandon Metcalf
- Re: Updating cidr column with network operator Michael Fuhr
- Re: add column if doesn't exist Peter Eisentraut
- how to do 'deep queries'? jeff sacksteder
- Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT Ferindo Middleton Jr
- Re: how to do 'deep queries'? Stewart Ben (RBAU/EQS4) *
- Re: how to do 'deep queries'? Anthony Molinaro
- Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT Tom Lane
- Re: Why doesn't the SERIAL data type automatically have a UNIQUE Ferindo Middleton Jr
- Re: how to do 'deep queries'? jeff sacksteder
- Re: add column if doesn't exist Brandon Metcalf
- Re: how to do 'deep queries'? Daryl Richter
- Re: Updating cidr column with network operator Daryl Richter
- Re: add column if doesn't exist Chris Browne
- Re: how to do 'deep queries'? Anthony Molinaro
- Re: Updating cidr column with network operator Axel Rau
- Re: Updating cidr column with network operator Daryl Richter
- Re: Updating cidr column with network operator Axel Rau
- Re: Why doesn't the SERIAL data type automatically have a Scott Marlowe
- Re: how to do 'deep queries'? Daryl Richter
- Re: how to do 'deep queries'? Anthony Molinaro
- Re: Updating cidr column with network operator Daryl Richter
- Re: Updating cidr column with network operator Axel Rau
- Re: Why doesn't the SERIAL data type automatically have a Scott Marlowe
- Re: how to do 'deep queries'? Daryl Richter
- Re: how to do 'deep queries'? Anthony Molinaro
- changing a column's position in table, how do you do that Ferindo Middleton Jr
- Re: changing a column's position in table, how do you do that Stewart Ben (RBAU/EQS4) *
- Re: changing a column's position in table, how do you do that Chris Browne
- changing a column's position in table, how do you do that Ferindo Middleton Jr
- Re: changing a column's position in table, how do you do that Stewart Ben (RBAU/EQS4) *
- Re: changing a column's position in table, how do you do that Chris Browne
- Re: add column if doesn't exist Brandon Metcalf
- Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT codeWarrior
- Sending function parametars within EXECUTE ''SELECT... Mario Splivalo
- Re: Sending function parametars within EXECUTE ''SELECT... codeWarrior
- Problem with function and trigger... Ian Meyer
- Re: Problem with function and trigger... Tom Lane
- Selecting count of details along with details columns Axel Rau
- Re: changing a column's position in table, how do you do that Daryl Richter
- Re: Problem with function and trigger... Ian Meyer
- Re: add column if doesn't exist Brandon Metcalf
- Re: changing a column's position in table, how do you do that Michael Glaesemann
- Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT codeWarrior
- Sending function parametars within EXECUTE ''SELECT... Mario Splivalo
- unsubscribe Ricky Sutanto
- unsubscribe noor@cs.man.ac.uk
- Re: unsubscribe Kenneth Gonsalves
- Re: Sending function parametars within EXECUTE ''SELECT... Mario Splivalo
- Re: Sending function parametars within EXECUTE ''SELECT... Stewart Ben (RBAU/EQS4) *
- Re: Sending function parametars within EXECUTE ''SELECT... Mario Splivalo
- Re: Selecting count of details along with details columns Richard Huxton
- Re: Selecting count of details along with details columns Axel Rau
- Re: Selecting count of details along with details columns Richard Huxton
- EXECUTE with SELECT INTO variable, or alternatives Mario Splivalo
- Re: Selecting count of details along with details columns Axel Rau
- Re: Selecting count of details along with details columns Scott Marlowe
- unsubscribe Ricky Sutanto
- EXECUTE SELECT INTO... last one! Mario Splivalo
- Re: EXECUTE SELECT INTO... last one! Michael Fuhr
- Re: EXECUTE SELECT INTO... last one! Mario Splivalo
- combination of function to simple query makes query slow jan aerts (RI)
- Re: combination of function to simple query makes query slow Jaime Casanova
- Re: EXECUTE with SELECT INTO variable, or alternatives Thomas F. O'Connell
- Re: EXECUTE with SELECT INTO variable, or alternatives Michael Fuhr