Mailing lists [pgsql-sql]
- How to connect ORACLE database from Postgres function using plpgsql/pltclu? Dinesh Pandey
- Re: bug in information_schema? Peter Eisentraut
- Re: How to connect ORACLE database from Postgres function using plpgsql/pltclu? Dawid Kuroczko
- Re: How to connect ORACLE database from Postgres function Sean Davis
- Re: How to connect ORACLE database from Postgres functionusing plpgsql/pltclu? Dinesh Pandey
- Calling SQL functions that return sets Chris Mungall
- Re: Calling SQL functions that return sets Tom Lane
- Re: Calling SQL functions that return sets Chris Mungall
- Re: Calling SQL functions that return sets Tom Lane
- Re: [NOVICE] Make year 01/01/0001 but leave timestamp alone daq
- Breakdown results by month Henry Ortega
- Trigger on select? Kyle Bateman
- Re: Trigger on select? Chris Travers
- Re: Trigger on select? Karsten Hilbert
-
Re: [NOVICE] SQL error code -601
daq - Re: Breakdown results by month codeWarrior
- NEW and OLD as ROWS Craig Servin
- Re: NEW and OLD as ROWS Michael Fuhr
- Re: Breakdown results by month Jeff Boes
- Make C file for create type Louise Catherine
- 'select where' using multiple columns. Rob Kirkbride
- Re: 'select where' using multiple columns. Ian Johannesen
- Re: 'select where' using multiple columns. daq
- Re: 'select where' using multiple columns. Hélder M. Vieira
- Re: 'select where' using multiple columns. Rob Kirkbride
- Re: Make C file for create type Richard Huxton
- sum but not grouped by? Henry Ortega
- Re: sum but not grouped by? Mischa Sandberg
- Re: sum but not grouped by? Henry Ortega
- Re: sum but not grouped by? PFC
- how to use column name with Case-sensitive with out usig "" wisan watcharinporn
- Re: how to use column name with Case-sensitive with out usig Ragnar Hafstað
- Caracter é Nicolas Cornu
- Re: [SQL] Caracter é PFC
- Re: Caracter é Frank Finner
- incorrect syntax for 'plpgsql' function to test boolean values Ferindo Middleton Jr
- Re: incorrect syntax for 'plpgsql' function to test boolean values John DeSoi
- Re: incorrect syntax for 'plpgsql' function to test boolean Ferindo Middleton Jr
- Re: sum but not grouped by? Mischa Sandberg
- Re: [NOVICE] Suspend Referential Integrity? daq
- unsubscribe Timothy Smith
- Faster count(*)? Owen Jacobson
- Re: **SPAM** Faster count(*)? dracula007@atlas.cz
- Re: **SPAM** Faster count(*)? Tom Lane
- Re: **SPAM** Faster count(*)? Michael Fuhr
- Re: **SPAM** Faster count(*)? Andrew Sullivan
- Re: **SPAM** Faster count(*)? Michael Fuhr
- Re: Faster count(*)? Richard Huxton
- Re: **SPAM** Faster count(*)? Owen Jacobson
- Re: Breakdown results by month Bruno Wolff III
- How to alias table columns in result? nori
- Re: How to alias table columns in result? Mischa Sandberg
- Re: How to alias table columns in result? nori
- Re: How to alias table columns in result? Nick Stone
- Re: How to alias table columns in result? nori
- Re: How to alias table columns in result? Jeff Boes
- Fwd: How to encrypt a column Jeff Lu
- Re: Fwd: How to encrypt a column Owen Jacobson
- Re: Fwd: How to encrypt a column Hélder M. Vieira
- Re: Fwd: How to encrypt a column Jeff Lu
- Re: Fwd: How to encrypt a column Owen Jacobson
- Re: Fwd: How to encrypt a column Bruno Wolff III
- about subselect Louise Catherine
- Re: about subselect Tom Lane
- Re: about subselect Louise Catherine
- Re: **SPAM** Faster count(*)? Keith Worthington
- unsubscribe Jack Tiger
- SQL Newbie Lane Van Ingen
- catch an 'update where false' ? santiago
- Re: catch an 'update where false' ? Alvaro Herrera
- Encrypting in Postgresql-8.0 The One
- Re: SQL Newbie Sean Davis
- Left join pa on dal resulting in null Ilene
- Re: SQL Newbie Nick Stone
- Re: SQL Newbie Bruno Wolff III
- Re: SQL Newbie Owen Jacobson
- Re: SQL Newbie Bruno Wolff III
- Re: Fwd: How to encrypt a column Bruno Wolff III
- Re: catch an 'update where false' ? santiago
- How to encrypt a column Jeff Lu
- insert into / select from / serial problem tgh002
- sql function: using set as argument Akshay Mathur
- Select problems Lucas Grijander
- Parentheses in FROM clause and evaluation order. dario.mx@gmail.com
- trigger between to different database Haris Saybasili
- Re: sum but not grouped by? Luca Rasconi Master
- Re: insert into / select from / serial problem Tom Lane
- Re: trigger between to different database Michael Fuhr
- Re: trigger between to different database Kenneth Gonsalves
- Re: catch an 'update where false' ? Alvaro Herrera
- Re: Select problems Richard Huxton
- Re: insert into / select from / serial problem PFC
- Re: catch an 'update where false' ? Richard Huxton
- Re: Parentheses in FROM clause and evaluation order. Stephan Szabo
- Re: catch an 'update where false' ? Lane Van Ingen
- Re: sql function: using set as argument Thomas F. O'Connell
- Problem with a Pettern Matching Check Sebastian Siewior
- Re: Problem with a Pettern Matching Check Dmitri Bichko
- Re: SUSPECT: RE: Re: Problem with a Pettern Matching Check Dmitri Bichko
- Re: Problem with a Pettern Matching Check Andreas Seltenreich
- Re: Problem with a Pettern Matching Check Michael Fuhr
- Re: Problem with a Pettern Matching Check Sebastian Siewior
- Re: Problem with a Pettern Matching Check Dmitri Bichko
- SQL output Simon Law
- Re: Problem with a Pettern Matching Check Tom Lane
- Re: SQL output Mischa Sandberg
- Re: Problem with a Pettern Matching Check Michael Fuhr
- Re: Problem with a Pettern Matching Check Tom Lane
- Re: Parentheses in FROM clause and evaluation order. Stephan Szabo
- Re: Parentheses in FROM clause and evaluation order. Tom Lane
- ARRAYs and INDEXes ... Marc G. Fournier
- Re: ARRAYs and INDEXes ... Michael Fuhr
- What libraries need to be included in C program for encrypt and decrypt functions? The One
- Re: ARRAYs and INDEXes ... Greg Stark
- Re: What libraries need to be included in C program for encrypt and decrypt functions? Owen Jacobson
- how to do a select * and decrypt a column at the same time? The One
- Re: how to do a select * and decrypt a column at the same time? Bruno Wolff III
- converting varchar to integer tv@fuzzy.cz
- Re: converting varchar to integer Josh Berkus
- Re: [despammed] converting varchar to integer Kretschmer Andreas
- Re: converting varchar to integer Halley Pacheco de Oliveira
- Re: [despammed] converting varchar to integer Frank Bax
- Is it This Join Condition Do-Able? Lane Van Ingen
- Re: Is it This Join Condition Do-Able? Michael Fuhr
- Re: Is it This Join Condition Do-Able? Dmitri Bichko
- Re: [despammed] converting varchar to integer A. Kretschmer
- Re: Is it This Join Condition Do-Able? Jeremy Semeiks
- Locating ( FKs ) References to a Primary Key Roger Motorola
- Re: Is it This Join Condition Do-Able? Dmitri Bichko
- Re: Locating ( FKs ) References to a Primary Key Dmitri Bichko
- Re: Is it This Join Condition Do-Able? Mischa Sandberg
- Re: Is it This Join Condition Do-Able? Tom Lane
- Re: Is it This Join Condition Do-Able? Ooh, ouch, blush Mischa Sandberg
- How to secure PostgreSQL Data for distribute? Premsun Choltanwanich
- Re: How to secure PostgreSQL Data for distribute? Pascual De Ruvo
- Re: How to secure PostgreSQL Data for distribute? Kenneth Gonsalves
- Re: How to secure PostgreSQL Data for distribute? Chris Travers
- Re: Locating ( FKs ) References to a Primary Key Roger Tannous
- Re: How to secure PostgreSQL Data for distribute? Christopher Browne
- Re: [despammed] converting varchar to integer Halley Pacheco de Oliveira
- A Table's Primary Key Listing Roger Tannous
- Re: A Table's Primary Key Listing Michael Fuhr
- Re: A Table's Primary Key Listing daq
- Re: A Table's Primary Key Listing D'Arcy J.M. Cain
- Re: A Table's Primary Key Listing Roger Tannous
- Re: A Table's Primary Key Listing Roger Tannous
- Re: A Table's Primary Key Listing D'Arcy J.M. Cain
- Re: A Table's Primary Key Listing Tom Lane
- dates and selection Joel Fradkin
- nevermind answered my own question by looking at my question what a DOH! Joel Fradkin
- Re: A Table's Primary Key Listing Roger Tannous
- Re: A Table's Primary Key Listing Roger Tannous
- Re: How to secure PostgreSQL Data for distribute? Ferindo Middleton Jr
- SQL CASE Statements Lane Van Ingen
- Re: SQL CASE Statements Dmitri Bichko
- Re: dates and selection Josh Berkus
- PGSQL function for converting between arbitrary numeric bases? Simon Kinsella
- Re: Parentheses in FROM clause and evaluation order. Dario Bahena Tapia
- Re: Parentheses in FROM clause and evaluation order. Dario Bahena Tapia
- pgsql-bugs Lee Hyun soon
- Updateing pg_trigger and pg_constraint Craig Servin
- Re: sql function: using set as argument Akshay Mathur
- Tables are not being updated Properly through Trigger Venkatesh Krishnamurthy
- Re: Tables are not being updated Properly through Trigger A. Kretschmer
- pl/PgSQL: Samples doing UPDATEs ... Marc G. Fournier
- Re: pl/PgSQL: Samples doing UPDATEs ... daq
- Re: pl/PgSQL: Samples doing UPDATEs ... Michael Fuhr
- Re: A Table's Primary Key Listing Roger Tannous
- [SOT] pypgsql function receiving dictionary as parameter? gherzig@fmed.uba.ar
- Re: [SOT] pypgsql function receiving dictionary as parameter? Michael Fuhr
- Re: [SOT] pypgsql function receiving dictionary as parameter? gherzig@fmed.uba.ar
- Re: PGSQL function for converting between arbitrary numeric bases? Bruno Wolff III
- Re: SQL CASE Statements Halley Pacheco de Oliveira
- Problem with self-made plpgsql-function / casting Moritz Bayer
- Re: Problem with self-made plpgsql-function / casting Mark Dingee
- Re: Problem with self-made plpgsql-function / casting Tom Lane
- Re: Problem with self-made plpgsql-function / casting Moritz Bayer
- Re: Problem with self-made plpgsql-function / casting Moritz Bayer
- Data insert Postgres Admin
- Re: [ADMIN] Data insert Michael Fuhr
- Re: A Table's Primary Key Listing Roger Tannous
- Problem calling stored procedure
- Re: SQL CASE Statements Lane Van Ingen
- Re: Problem calling stored procedure Michael Fuhr
- Re: Problem calling stored procedure Stephan Szabo
- Re: A Table's Primary Key Listing Alvaro Herrera
- PL/SQL Function: self-contained transaction? Marc G. Fournier
- Re: PL/SQL Function: self-contained transaction? Greg Stark
- Re: PL/SQL Function: self-contained transaction? A. Kretschmer
- Why Doesn't SQL This Expression Work? Lane Van Ingen
- Re: Why Doesn't SQL This Expression Work? Dmitri Bichko
- Re: Why Doesn't SQL This Expression Work? Stephan Szabo
- Re: Why Doesn't SQL This Expression Work? Lane Van Ingen
- Re: PL/SQL Function: self-contained transaction? Richard_D_Levine@raytheon.com
- Re: SQL CASE Statements Halley Pacheco de Oliveira
- Re: [PHP] [ADMIN] Data insert Jim C. Nasby
- diary constraints Gary Stainburn
- Re: diary constraints
- Re: diary constraints Michael Glaesemann
- Re: diary constraints Gnanavel S
- Re: diary constraints PFC
- Re: diary constraints A. Kretschmer
- Re: Problem calling stored procedure
- Re: Problem calling stored procedure Tom Lane
- Tuple insert missing query in ongoing transaction Szűcs Gábor
- Re: Problem calling stored procedure
- Re: Problem calling stored procedure
- Re: Problem calling stored procedure
- Number of rows in a cursor ? Bo Lorentsen
- Re: Number of rows in a cursor ? Thomas Borg Salling
- Re: Tuple insert missing query in ongoing transaction Szűcs Gábor
- Re: Number of rows in a cursor ?
- Re: Number of rows in a cursor ? Bo Lorentsen
- Re: Number of rows in a cursor ? Bo Lorentsen
- SQLException - SET AUTOCOMMIT TO OFF is no longer supported Dinesh Pandey
- Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Dinesh Pandey
- Re: Number of rows in a cursor ? Russell Simpkins
- Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Russell Simpkins
- Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Russell Simpkins
- Re: Number of rows in a cursor ? John DeSoi
- Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Joel Fradkin
- Re: Number of rows in a cursor ? Bo Lorentsen
- Re: Number of rows in a cursor ? Michael Fuhr
- How to join several selects Josep Sanmartí
- Re: How to join several selects Sean Davis
- Re: How to join several selects Rod Taylor
- Re: How to join several selects Michael Glaesemann
- Re: Number of rows in a cursor ? Bo Lorentsen
- Re: How to join several selects Zac
- Re: Number of rows in a cursor ? Michael Fuhr
- Re: how to do a select * and decrypt a column at the same Scott Marlowe
- Can EXCEPT Be Used for To Solve This Problem? Lane Van Ingen
- Re: Can EXCEPT Be Used for To Solve This Problem? Michael Fuhr
- Re: Can EXCEPT Be Used for To Solve This Problem? Tom Lane
- Re: Can EXCEPT Be Used for To Solve This Problem? Michael Fuhr
- Re: Number of rows in a cursor ? Bo Lorentsen
- table listing queries Daniel Silverstone
- Re: table listing queries Sean Davis
- Re: table listing queries Hélder M. Vieira
- Re: Number of rows in a cursor ? Bruno Wolff III
- Re: How this query! Bruno Wolff III
- Re: Can EXCEPT Be Used for To Solve This Problem? Vivek Khera
- Re: Can EXCEPT Be Used for To Solve This Problem? Mark R. Dingee
- Tidying values on variable instantiation Bath, David
- Re: Tidying values on variable instantiation Michael Glaesemann
- Re: Tidying values on variable instantiation Russell Simpkins
- Re: Tidying values on variable instantiation Greg Patnude
- Re: Tidying values on variable instantiation Bruno Wolff III
- Re: Tidying values on variable instantiation Chris Browne
- Re: Tidying values on variable instantiation Chris Browne
- Common patterns for 'store' functions Chris Mungall
- booleans and nulls Matt L.
- Numerical variables in pqsql statements Michael Schmidt
- question Matt A.
- nullif('','') on insert Matt L.
- returning inserted id Matt A.
- Unwanted nested dollar-quoted constants Bernard Henry Voynet
- Re: returning inserted id Bruno Wolff III
- Re: booleans and nulls Chris Travers
- Re: nullif('','') on insert Chris Travers
- Re: returning inserted id Havasvölgyi Ottó
- Re: nullif('','') on insert Bruno Wolff III
- Re: Unwanted nested dollar-quoted constants Tom Lane
- PostgreSQL help Shavonne Marietta Wijesinghe
- Re: PostgreSQL help PFC
- Negative lookbehind assertions in regexs Julian Scarfe
- Re: Negative lookbehind assertions in regexs Bruno Wolff III
- sqlstate 02000 while declaring cursor/freeing prepared statements andy rost
- Re: Numerical variables in pqsql statements Thomas F. O'Connell
- Re: sqlstate 02000 while declaring cursor/freeing prepared statements Michael Fuhr
- Re: question Thomas F. O'Connell
- Re: sqlstate 02000 while declaring cursor/freeing prepared andy rost
- Re: sqlstate 02000 while declaring cursor/freeing prepared andy rost
- Re: sqlstate 02000 while declaring cursor/freeing prepared Michael Fuhr
- Performance issue Ricky Sutanto
- Time differences between rows, not columns?
- Re: Time differences between rows, not columns? Anthony Molinaro
- Re: REINDEX DATABASE Achilleus Mantzios
- Re: Time differences between rows, not columns?
- Re: Time differences between rows, not columns? Anthony Molinaro
- Re: Performance issue Michael Fuhr
- Re: Performance issue Bruno Wolff III
- Re: question Halley Pacheco de Oliveira
- Re: question Vivek Khera
- Re: Numerical variables in pqsql statements Thomas F. O'Connell
- plpgsql question Postgres Admin
- Re: [ADMIN] plpgsql question Michael Fuhr
- Re: [ADMIN] plpgsql question Postgres Admin
- Re: booleans and nulls Scott Marlowe
- Re: sqlstate 02000 while declaring cursor/freeing prepared andy rost
- Re: [ADMIN] plpgsql question Michael Fuhr
- How do I copy part of table from db1 to db2 (and rename the columns)? Joost Kraaijeveld
- Re: How do I copy part of table from db1 to db2 (and rename the columns)? Kenneth Gonsalves
- Re: [GENERAL] How do I copy part of table from db1 to db2 (and Joost Kraaijeveld
- Re: [GENERAL] How do I copy part of table from db1 to db2 (and Thomas Pundt
- Re: [GENERAL] How do I copy part of table from db1 to db2 (and Thomas Pundt
- psql commandline dIGITx
- Re: psql commandline Kenneth Gonsalves
- Re: psql commandline digit-x@gmx.net
- Re: psql commandline Kenneth Gonsalves
- Re: psql commandline digit-x@gmx.net
- Re: psql commandline Zac
- Re: How do I copy part of table from db1 to db2 (and rename the columns)? Greg Sabino Mullane
- Re: psql commandline Kenneth Gonsalves
- Re: psql commandline Kenneth Gonsalves
- Re: [GENERAL] How do I copy part of table from db1 to db2 (and Tom Lane
- Re: [GENERAL] How do I copy part of table from db1 to db2 Joost Kraaijeveld
- insert only if conditions are met? Henry Ortega
- Re: [GENERAL] How do I copy part of table from db1 to db2 Joost Kraaijeveld
- Re: insert only if conditions are met? Tom Lane
- Re: insert only if conditions are met? Michael Fuhr
- Re: insert only if conditions are met? Henry Ortega
- Re: insert only if conditions are met? Ragnar Hafstað
- Re: insert only if conditions are met? Henry Ortega
- Re: insert only if conditions are met? Jim C. Nasby
- Re: insert only if conditions are met? Ragnar Hafstað
- Re: insert only if conditions are met? Philip Hallstrom
- Re: insert only if conditions are met? Scott Marlowe
- Re: insert only if conditions are met? Daryl Richter