Mailing lists [pgsql-sql]
- Re: Function in C++ TJ O'Donnell
- one table being used for two purposes with foreign key for each? Miles Keaton
- Re: Formatting an Interval Karel Zak
- Re: Formatting an Interval Michael Fuhr
- Re: Formatting an Interval Kretschmer Andreas
- Re: Formatting an Interval Pierre-Frédéric Caillaud
- Re: Formatting an Interval Edmund Bacon
- foreign key problems BARTKO, Zoltán
- Re: foreign key problems Stephan Szabo
- Calling a table residing in another database from Plpgsql deepthi@granwill.com
- Calling a table in another database from plpgsql deepthi@granwill.com
- Re: Calling a table residing in another database from Plpgsql Kenneth Gonsalves
- Re: foreign key problems BARTKO, Zoltán
- Re: foreign key problems Stephan Szabo
- Re: foreign key problems Stephan Szabo
- Re: [JDBC] Calling a table in another database from plpgsql Kris Jurka
- Re: Calling a table residing in another database from Plpgsql Joe Conway
- Re: Calling a table residing in another database from Plpgsql Kretschmer Andreas
- plpsql function problem drdani@mazsola.iit.uni-miskolc.hu
- Re: plpsql function problem Tom Lane
- undigested email TJ O'Donnell
- vararg plpsql function drdani@mazsola.iit.uni-miskolc.hu
- View with Union and update rule - fails Filip Jirsák
- simulating row ownership Rick Schumeyer
- Re: View with Union and update rule - fails Tom Lane
- Re: simulating row ownership Michael Fuhr
- Re: [JDBC] Calling a table in another database from plpgsql Dave Cramer
- Re: Calling a table residing in another database from Plpgsql CoL
- Question about insert/update RULEs. Dmitri Bichko
- Easier way to 'strip' on multiple matches? Marc G. Fournier
- TEXT blob extraction in ecpg none none
- Re: TEXT blob extraction in ecpg Michael Fuhr
- Re: Question about insert/update RULEs. Ron Peterson
- Parsing a Calculation from a field Kieran Ashley
- Re: Parsing a Calculation from a field Richard Huxton
- Re: simulating row ownership Ron Peterson
- Re: simulating row ownership Ron Peterson
- Re: Parsing a Calculation from a field Kieran Ashley
- Single row tables KÖPFERL Robert
- Re: Parsing a Calculation from a field Jeff Eckermann
- Re: Single row tables Dmitri Bichko
- Re: Single row tables KÖPFERL Robert
- Simple Question Terry Lee Tucker
- Re: Simple Question Guy Fraser
- Re: Simple Question Terry Lee Tucker
- Re: Simple Question Michael Fuhr
- Re: Simple Question Stephan Szabo
- Re: Simple Question Terry Lee Tucker
- Re: Simple Question Terry Lee Tucker
- Re: Simple Question Tom Lane
- Re: Single row tables sad
- Implementing queue semantics (novice) KÖPFERL Robert
- Re: Implementing queue semantics (novice) Andrew Hammond
- Problems with HAVING Kaloyan Iliev Iliev
- failed to find conversion function from "unknown" to text Szűcs Gábor
- Syntax error while altering col-type KÖPFERL Robert
- Re: Problems with HAVING Michael Fuhr
- Re: Syntax error while altering col-type Michael Fuhr
- Re: failed to find conversion function from "unknown" to text Tom Lane
- Re: Syntax error while altering col-type Rosser Schwarz
- Re: failed to find conversion function from "unknown" to text Andrew Sullivan
- Re: Problems with HAVING Sam Mason
- Re: Problems with HAVING Michael Fuhr
- Recursive query to be used in another result ? Bradley Miller
- Problems with Quotes Kieran Ashley
- Re: Problems with Quotes John DeSoi
- Re: Problems with Quotes Kieran Ashley
- Re: Problems with HAVING Kaloyan Iliev Iliev
- Re: Problems with HAVING Kaloyan Iliev Iliev
- Re: Problems with Quotes Edmund Bacon
- Re: Problems with Quotes Kieran Ashley
- Re: Problems with Quotes Michael Fuhr
- Re: Problems with Quotes John DeSoi
- Re: Implementing queue semantics (novice) KÖPFERL Robert
- Re: Syntax error while altering col-type KÖPFERL Robert
- Re: Syntax error while altering col-type Sam Mason
- Columns into rows. Dawid Kuroczko
- Re: Columns into rows. Dawid Kuroczko
- Re: Columns into rows. Dawid Kuroczko
- RE RE: Single row tables KÖPFERL Robert
- Re: Syntax error while altering col-type Andrew Sullivan
- Re: Syntax error while altering col-type KÖPFERL Robert
- Re: Syntax error while altering col-type Andrew Sullivan
- Column with recycled sequence value KÖPFERL Robert
- Re: Column with recycled sequence value Bruno Wolff III
- Re: Column with recycled sequence value Andrew Sullivan
- Re: Column with recycled sequence value Scott Marlowe
- Re: Column with recycled sequence value Michael Fuhr
- Re: Column with recycled sequence value Scott Marlowe
- Re: Column with recycled sequence value Andrew Sullivan
- Re: Column with recycled sequence value Michael Fuhr
- Re: Column with recycled sequence value Scott Marlowe
- Re: Column with recycled sequence value Andrew Sullivan
- Re: Column with recycled sequence value PFC
- pgmirror Theo Galanakis
- Re: Column with recycled sequence value Greg Stark
- Trick to 'run' a view on two databases and combine the result ? Din Adrian
- Re: Column with recycled sequence value KÖPFERL Robert
- Re: Trick to 'run' a view on two databases and combine the result ? Michael Fuhr
- Re: Column with recycled sequence value (solved (somehow)) KÖPFERL Robert
- assign the row count of a query to a variable Kevin B.
- Re: assign the row count of a query to a variable PFC
- Re: assign the row count of a query to a variable Michael Fuhr
- SQL Query Performance tips Michael Ossareh
- return value of the trigger function Jarek Pudełko
- TEXT type blob extraction in ecpg none none
- I am writing a MS SQL server conversion utility and am having an issue with timestamp Joel Fradkin
- Re: SQL Query Performance tips PFC
- Re: return value of the trigger function Bruno Wolff III
- Split pg_dump script Markus Schaber
- SQL design question: null vs. boolean values j.random.programmer
- Re: SQL design question: null vs. boolean values Andrew Sullivan
- Re: SQL design question: null vs. boolean values Richard Huxton
- Re: I am writing a MS SQL server conversion utility and am having an issue with timestamp Michael Fuhr
- Re: SQL design question: null vs. boolean values j.random.programmer
- Re: SQL design question: null vs. boolean values PFC
- Re: pgmirror Theo Galanakis
- Re: TEXT type blob extraction in ecpg KÖPFERL Robert
- Record type in sql Din Adrian
- Re: Record type in sql KÖPFERL Robert
- Inserting or Deleting conditionally KÖPFERL Robert
- Re: Inserting or Deleting conditionally Richard Huxton
- plpgsql and for with integer loopvar error Ari Kahn
- query configuration for validate empty quote to zero Yudie
- Re: query configuration for validate empty quote to zero Tom Lane
- Re: plpgsql and for with integer loopvar error Stephan Szabo
- Re: query configuration for validate empty quote to zero Yudie
- "How do I ..." SQL question zeus@ix.netcom.com
- Re: "How do I ..." SQL question PFC
- mail + rfc822, rfc2822 + schema Achilleus Mantzios
- Re: query configuration for validate empty quote to zero KÖPFERL Robert
- Returning a bool on DELETE in a proc. KÖPFERL Robert
- Re: Returning a bool on DELETE in a proc. Keith Worthington
- Re: Returning a bool on DELETE in a proc. Michael Fuhr
- postgres stored procedures Joel Fradkin
- URGENT: Using function inside query Bradley Miller
- Re: mail + rfc822, rfc2822 + schema Ron Peterson
- Re: URGENT: Using function inside query Michael Fuhr
- Looking for examples of S/P KÖPFERL Robert
- Re: Looking for examples of S/P Michael Fuhr
- Re: Returning a bool on DELETE in a proc. KÖPFERL Robert
- Re: mail + rfc822, rfc2822 + schema Achilleus Mantzios
- Re: Returning a bool on DELETE in a proc. Richard Huxton
- Re: Looking for examples of S/P RobertD.Stewart@ky.gov
- Re: Returning a bool on DELETE in a proc. Karsten Hilbert
- Re: Looking for examples of S/P John DeSoi
- Conversion ideas (Views/procedures) Joel Fradkin
- Re: Conversion ideas (Views/procedures) KÖPFERL Robert
- Re: Returning a bool on DELETE in a proc. Michael Fuhr
- Re: Returning a bool on DELETE in a proc. KÖPFERL Robert
- Re: Conversion ideas (Views/procedures) Keith Worthington
- ERROR: row is too big: size 9856, maximum size 8136 Joel Fradkin
- Re: Returning a bool on DELETE in a proc. Michael Fuhr
- include in both ecpg and C++ none none
- Re: ERROR: row is too big: size 9856, maximum size 8136 Michael Fuhr
- Query performance and understanding explain analzye Benjamin Wragg
- SQL timestamp to date cast Andrei Bintintan
- Re: SQL timestamp to date cast Michael Fuhr
- Problem on Geometric functions Silke Trissl
- Re: SQL timestamp to date cast Andrei Bintintan
- Re: SQL timestamp to date cast Michael Fuhr
- Re: Problem on Geometric functions Michael Fuhr
- OID's Mihail Nasedkin
- OFFSET impact on Performance??? Andrei Bintintan
- Re: OFFSET impact on Performance??? Richard Huxton
- Re: OFFSET impact on Performance??? Andrei Bintintan
- Re: ERROR: row is too big: size 9856, maximum size 8136 Joel Fradkin
- pg_user relationship does not exist Joel Fradkin
- Re: pg_user relationship does not exist Achilleus Mantzios
- Re: OFFSET impact on Performance??? Richard Huxton
- Re: ERROR: row is too big: size 9856, maximum size 8136 Michael Fuhr
- automatic table locking on too many locked records? KÖPFERL Robert
- Re: OID's Michael Fuhr
- Re: [PERFORM] OFFSET impact on Performance??? Richard Huxton
- Re: OFFSET impact on Performance??? Greg Stark
- Re: automatic table locking on too many locked records? Richard Huxton
- Re: ERROR: row is too big: size 9856, maximum size 8136 Joel Fradkin
- Re: OFFSET impact on Performance??? Richard Huxton
- Re: ERROR: row is too big: size 9856, maximum size 8136 Richard Huxton
- Re: ERROR: row is too big: size 9856, maximum size 8136 Tom Lane
- Re: ERROR: row is too big: size 9856, maximum size 8136 Joel Fradkin
- still having pg_user error Joel Fradkin
- Re: still having pg_user error Tom Lane
- Re: OID's Mihail Nasedkin
- Re: [PERFORM] OFFSET impact on Performance??? Andrei Bintintan
- returning a record from PL/pgSQL KÖPFERL Robert
- Re: still having pg_user error Joel Fradkin
- Re: still having pg_user error Tom Lane
- Re: still having pg_user error Joel Fradkin
- Re: OID's Michael Fuhr
- Re: OID's Richard Huxton
- testing/predicting optimization using indexes TJ O'Donnell
- update from multiple rows adam etienne
- Question about a select Kretschmer Andreas
- Re: update from multiple rows Michael Fuhr
- editors with colum positioning for debugging? Joel Fradkin
- Re: editors with colum positioning for debugging? Tom Lane
- Re: editors with colum positioning for debugging? Joel Fradkin
- Re: editors with colum positioning for debugging? John DeSoi
- Re: update from multiple rows adam etienne
- Re: Question about a select Harald Fuchs
- Re: returning a record from PL/pgSQL Michael Fuhr
- Invalid Input syntax for type bigint Ryan Miranda
- Re: OID's Mihail Nasedkin
- Re: Invalid Input syntax for type bigint Michael Fuhr
- Re: OID's Michael Fuhr
- Re: OID's Mihail Nasedkin
- Re: update from multiple rows Michael Fuhr
- How to find out programmatically whether a query on a view will use an index? Martin Schäfer
- Re: How to find out programmatically whether a query on a view will use an index? Tom Lane
- Re: How to find out programmatically whether a query on a view will use an index? Martin Schäfer
- Re: update from multiple rows franco
- Value specific sequences? Dmitri Bichko
- datediff is there something like it? Joel Fradkin
- Re: datediff is there something like it? Achilleus Mantzios
- difficult JOIN Thomas Chille
- Re: How to find out programmatically whether a query on a view will use an index? Bruno Wolff III
- Re: "How do I ..." SQL question zeus@ix.netcom.com
- converting Oracle scripts to PostgreSQL Gary Broadbent
- Re: "How do I ..." SQL question Bob
- Re: [PERFORM] OFFSET impact on Performance??? Alex Turner
- Re: [PERFORM] OFFSET impact on Performance??? Ragnar Hafstað
- Re: [PERFORM] OFFSET impact on Performance??? Spiegelberg, Greg
- Re: [PERFORM] OFFSET impact on Performance??? Ragnar Hafstað
- Re: datediff is there something like it? Joel Fradkin
- Re: converting Oracle scripts to PostgreSQL Dennis Sacks
- Re: [PERFORM] OFFSET impact on Performance??? Greg Stark
- Moving from Transact SQL to PL/pgsql Duffy House
- Looking up table names by REFERENCES Steve Castellotti
- Moving from Transact SQL to PL/pgSQL Kevin Duffy
- Re: converting Oracle scripts to PostgreSQL Clint Stotesbery
- Re: update from multiple rows mrblonde@locked.myftp.org
- How to update dependent tables AND design considerations Klaus W.
- Re: datediff is there something like it? Oleg Bartunov
- Re: Looking up table names by REFERENCES Michael Fuhr
- Re: Moving from Transact SQL to PL/pgSQL Michael Fuhr
- Re: Moving from Transact SQL to PL/pgSQL Dennis Sacks
- Re: How to update dependent tables AND design considerations Thomas F.O'Connell
- Re: Moving from Transact SQL to PL/pgsql John DeSoi
- Re: update from multiple rows Franco Bruno Borghesi
- same question little different test MSSQL vrs Postgres Joel Fradkin
- Sorry I see my first question did not get posted (maybe because of the attatchments) Joel Fradkin
- Re: same question little different test MSSQL vrs Postgres Dennis Sacks
- Re: same question little different test MSSQL vrs Postgres Greg Stark
- working with multidimensional arrays in plpgsql Sibtay Abbas
- private table Din Adrian
- Re: [despammed] private table Andreas Kretschmer
- Re: Sorry I see my first question did not get posted (maybe Richard Huxton
- Re: private table Richard Huxton
- Re: How to find out programmatically whether a query on a view will use an index? Martin Schäfer
- Re: working with multidimensional arrays in plpgsql Richard Huxton
- Re: [PERFORM] OFFSET impact on Performance??? Andrei Bintintan
- Re: working with multidimensional arrays in plpgsql Sibtay Abbas
- Re: same question little different test MSSQL vrs Postgres Joel Fradkin
- Re: [PERFORM] OFFSET impact on Performance??? Richard Huxton
- Re: same question little different test MSSQL vrs Postgres Richard Huxton
- Re: same question little different test MSSQL vrs Postgres Joel Fradkin
- Re: Moving from Transact SQL to PL/pgsql George Essig
- Re: same question little different test MSSQL vrs Postgres Richard Huxton
- Re: ***SPAM*** Re: same question little different test MSSQL Franco Bruno Borghesi
- Re: same question little different test MSSQL vrs Postgres Joel Fradkin
- Re: same question little different test MSSQL vrs Postgres Greg Stark
- Re: same question little different test MSSQL vrs Postgres Richard Huxton
- Re: same question little different test MSSQL vrs Postgres Joel Fradkin
- Re: same question little different test MSSQL vrs Postgres Greg Stark
- Re: same question little different test MSSQL vrs Postgres Joel Fradkin
- Re: ***SPAM*** Re: same question little different test MSSQL Franco Bruno Borghesi
- Re: same question little different test MSSQL vrs Postgres Richard Huxton
- Re: working with multidimensional arrays in plpgsql Josh Berkus
- Re: datediff is there something like it? Bruno Wolff III
- Re: same question little different test MSSQL vrs Postgres Bruno Wolff III
- Re: same question little different test MSSQL vrs Postgres Dennis Sacks
- Re: testing/predicting optimization using indexes PFC
- Re: same question little different test MSSQL vrs Postgres Andrew Hammond
- Re: testing/predicting optimization using indexes TJ O'Donnell
- Re: testing/predicting optimization using indexes PFC
- Rule problem with OLD / NEW record set Ralph Graulich
- Re: Moving from Transact SQL to PL/pgSQL Clint Stotesbery
- Complete instruction in a trigger Wilton
- Re: Complete instruction in a trigger Richard Huxton
- Constraint on 2 column possible? Andrei Bintintan
- Re: Constraint on 2 column possible? Mike Rylander
- Re: Constraint on 2 column possible? Sean Davis
- What's the equivalent in PL/pgSQL KÖPFERL Robert
- Re: Complete instruction in a trigger Wilton
- Foreign Key relationship between two databases Sandeep Gaikwad
- Re: Foreign Key relationship between two databases Stephan Szabo
- Re: What's the equivalent in PL/pgSQL Sean Davis
- Re: [GENERAL] Foreign Key relationship between two databases Dawid Kuroczko
- Re: same question little different test MSSQL vrs Postgres Joel Fradkin
- Hardware for best performance was same question little different test MSSQL vrs Postgres Joel Fradkin
- URL activation through trigger Sandeep Gaikwad
- Re: Complete instruction in a trigger Tom Lane
- Re: URL activation through trigger Sean Davis
- Re: What's the equivalent in PL/pgSQL KÖPFERL Robert
- Function Doubt Wilton
- hardware mod based on feedback from the list Joel Fradkin
- Re: hardware mod based on feedback from the list Richard Huxton
- Re: Function Doubt Richard Huxton
- Re: hardware mod based on feedback from the list Keith Worthington
- Re: What's the equivalent in PL/pgSQL Sean Davis
- Re: contrib/intarray doc/tutorial needed Achilleus Mantzios
- ... Deepthi Darshan
- Re: Richard Huxton
- calling JAVA UDF through trigger Swati Gadre
- Calendar Function Muhyiddin A.M Hayat
- error: cast the timestam expression friendVU admin
- Re: error: cast the timestam expression Tom Lane
- Re: error: cast the timestam expression Michael Glaesemann
- Re: Calendar Function Franco Bruno Borghesi
- plpgsql select into with multiple target variables John DeSoi
- Re: plpgsql select into with multiple target variables PFC
- plpgsql functions and NULLs Don Drake
- Re: plpgsql functions and NULLs Thomas F.O'Connell