Mailing lists [pgsql-sql]
- Re: [GENERAL] arrays Achilleus Mantzios
- alter user does not changes password Lucas Brasilino
- Re: alter user does not changes password dima
- Re: alter user does not changes password Tom Lane
- Re: [GENERAL] arrays Roland Roberts
- Re: [GENERAL] arrays Josh Berkus
- Stored Procedures bcschnei@attbi.com
- Re: Stored Procedures Roberto Mello
- please help with converting a view in oracle into postgresql readably code mgeddert
- Re: please help with converting a view in oracle into postgresql readably code Roberto Mello
- split function for pl/pgsql Frederic Logier
- Re: PROBLEM SOLVED RE: please help with converting a view in oracle into postgresql readably code Roberto Mello
- Re: Stored Procedures david williams
- Re: Stored Procedures david williams
- Re: split function for pl/pgsql Joe Conway
- Re: Stored Procedures Joe Conway
- indexing on char vs varchar Beth Gatewood
- Re: split function for pl/pgsql Frederic Logier
- Re: indexing on char vs varchar Bruce Momjian
- Updating from select Thrasher
- Re: indexing on char vs varchar Beth Gatewood
- Re: Updating from select Manfred Koizar
- Re: indexing on char vs varchar Josh Berkus
- Re: Stored Procedures bcschnei@attbi.com
- Re: indexing on char vs varchar Josh Berkus
- Re: Stored Procedures david williams
- Re: indexing on char vs varchar Beth Gatewood
- Re: Stored Procedures Joe Conway
- schedule of v7.3 Jie Liang
- celko nested set functions Robert Treat
- Re: schedule of v7.3 Bruce Momjian
- Re: celko nested set functions Josh Berkus
- Re: split function for pl/pgsql Joe Conway
- Re: Updating from select Thrasher
- Formatting current_time output Thomas Good
- epoch to date Roberto Mello
- Re: Formatting current_time output Josh Berkus
- Re: Formatting current_time output Achilleus Mantzios
- Re: Formatting current_time output Charles H. Woloszynski
- Re: Formatting current_time output Thomas Good
- Re: Formatting current_time output Karel Zak
- Re: epoch to date Achilleus Mantzios
- drop constraint primary key Marie G. Tuite
- Re: drop constraint primary key Tom Lane
- order by x DESC, y ASC indexing problem Vincent-Olivier Arsenault
- Re: order by x DESC, y ASC indexing problem Josh Berkus
- Re: order by x DESC, y ASC indexing problem Bruno Wolff III
- Re: order by x DESC, y ASC indexing problem Bruno Wolff III
- Re: order by x DESC, y ASC indexing problem Tom Lane
- rows in order Camila Rocha
- please help with converting a view in oracle into postgresql readably code Matthew Geddert
- Can Postgres cache a table in memory? Kevin Traub
- How slow is distinct - 2nd Michael Contzen
- Re: [GENERAL] CURRENT_TIMESTAMP Martijn van Oosterhout
- Rule creation Edoardo Causarano
- Re: [GENERAL] CURRENT_TIMESTAMP Martijn van Oosterhout
- Re: Can Postgres cache a table in memory? Achilleus Mantzios
- Re: rows in order Achilleus Mantzios
- Re: please help with converting a view in oracle into postgresql readably code Tom Lane
- Re: Can Postgres cache a table in memory? Richard Huxton
- Re: rows in order Richard Huxton
- Re: Can Postgres cache a table in memory? Tom Lane
- Re: Rule creation Tom Lane
- Re: How slow is distinct - 2nd Tom Lane
- Re: How slow is distinct - 2nd Bruno Wolff III
- Re: rows in order Oleg Bartunov
- Re: Can Postgres cache a table in memory? Josh Berkus
- Re: rows in order Joe Conway
- Self Join? bens_nospam@benjamindsmith.com
- enforcing with unique indexes.. Rajesh Kumar Mallah.
- Re: enforcing with unique indexes.. Rajesh Kumar Mallah.
- Re: enforcing with unique indexes..
- problem with subqueries pete@phillipsfamily.freeserve.co.uk
- Re: problem with subqueries Tom Lane
- Re: problem with subqueries Stephan Szabo
- Re: problem with subqueries pete@phillipsfamily.freeserve.co.uk
- Suggestion: md5/crypt functions in sql Aasmund Midttun Godal
- Re: problem with subqueries Stephan Szabo
- Re: Suggestion: md5/crypt functions in sql Joe Conway
- Re: Suggestion: md5/crypt functions in sql Dan Langille
- sum function Dagoberto Torres
- timestamp Brian Ward
- Get A Tree from a table gzscott2001@yahoo.ca (Scott Yaung)
- Re: timestamp Brian Ward
- Need some SQL help Brian Ward
- Re: [GENERAL] arrays scott.marlowe
- Re: timestamp Larry Rosenman
- Re: Need some SQL help Dan Langille
- Re: timestamp Dan Langille
- Re: timestamp Dan Langille
- Re: enforcing with unique indexes.. Jean-Luc Lachance
- Re: Get A Tree from a table Josh Berkus
- Re: Get A Tree from a table Joe Conway
- Problems Formulating a SELECT Charles Hauser
- Debug information Rafal Kedziorski
- SQL Error Rafal Kedziorski
- foreign key problem Laurette Cisneros
- Re: foreign key problem Josh Berkus
- Re: foreign key problem Josh Berkus
- Re: foreign key problem Stephan Szabo
- Probs "compiling" a function gordoncl@optusnet.com.au
- Temporary tables and indexes Ludwig Lim
- Re: Probs "compiling" a function Richard Huxton
- Re: Problems Formulating a SELECT Richard Huxton
- foreign key, on delete cascade... Mathieu Arnold
- Re: foreign key, on delete cascade... Stephan Szabo
- Re: Problems Formulating a SELECT Charles Hauser
- Re: Temporary tables and indexes Josh Berkus
- Re: [NOVICE] update question Josh Berkus
- Re: How slow is distinct - 2nd Michael Contzen
- Re: Temporary tables and indexes Ian Harding
- Re: Problems Formulating a SELECT Richard Huxton
- Re: Problems Formulating a SELECT Charles Hauser
- Table Rule Rudi Starcevic
- Re: IN, EXISTS or ANY? Keith Gray
- Re: IN, EXISTS or ANY? Josh Berkus
- Re: Temporary tables and indexes Tom Lane
- Re: Temporary tables and indexes Josh Berkus
- Re: Problems Formulating a SELECT Richard Huxton
- PLPGSQL errors Rudi Starcevic
- Re: PLPGSQL errors Richard Huxton
- Complex SQL query and performance strategy Adam Witney
- Re: Complex SQL query and performance strategy Tom Lane
- problem with the Index Jose Antonio Leo
- SELECT statement never completes. John Pauley
- Re: SELECT statement never completes. Stephan Szabo
- Re: problem with the Index Stephan Szabo
- Re: foreign key problem Laurette Cisneros
- Viewing stored procedure code Ludwig Lim
- Re: Viewing stored procedure code Achilleus Mantzios
- Re: SQL Error Christoph Haller
- Re: SQL Error Achilleus Mantzios
- SELECT with INNER data bases 2000 Informática
- Re: SELECT with INNER data bases Bruno Wolff III
- Re: SELECT with INNER data bases Roberto Mello
- NOTICE: generated by sequence nextval() John Duffy
- ... Luis Mix
- Re: NOTICE: generated by sequence nextval() Michael Ansley (UK)
- Re: NOTICE: generated by sequence nextval() Thrasher
- triggers Stian Riis
- Re: triggers Richard Huxton
- Re: triggers Achilleus Mantzios
- Missing Review Josh Berkus
- DELETE command is getting blocked Bhuvan A
- Re: DELETE command is getting blocked Stephan Szabo
- Stored procedure returning row or resultset Heiko Stoermer
- Re: Stored procedure returning row or resultset Brian Blaha
- Re: Stored procedure returning row or resultset Richard Huxton
- Re: Stored procedure returning row or resultset Tom Lane
- Slow performance on MAX(primary_key) Keith Gray
- SQL function triggers Brian Blaha
- Re: Slow performance on MAX(primary_key) Ludwig Lim
- Re: Slow performance on MAX(primary_key) Keith Gray
- Re: Stored procedure returning row or resultset Richard Huxton
- Re: Slow performance on MAX(primary_key) Richard Huxton
- how do i insert an empty string ? Peter Galbavy
- Re: how do i insert an empty string ? Peter Galbavy
- Re: IGNORE ME how do i insert an empty string ? Peter Galbavy
- Messy Casts, Is there a better way? Larry Rosenman
- set difference Domoszlai László
- Re: Stored procedure returning row or resultset Tom Lane
- Re: SQL function triggers Tom Lane
- Re: how do i insert an empty string ? Jeff
- Re: set difference Tom Lane
- Re: Messy Casts, Is there a better way? Josh Berkus
- Re: Messy Casts, Is there a better way? Peter Eisentraut
- int id's helpful for indexing, or just use text names? george young
- ADO with postgreSQL 2000 Informática
- Re: int id's helpful for indexing, or just use text names? Tom Lane
- Re: SQL function triggers Jan Wieck
- replace null with 0 in subselect ? Albrecht Berger
- Locking that will delayed a SELECT Ludwig Lim
- Re: replace null with 0 in subselect ? Ian Barwick
- pg_atoi() error alexandre :: aldeia digital
- Re: set difference Domoszlai László
- Re: set difference Tom Lane
- Re: replace null with 0 in subselect ? Stephan Szabo
- Use of reference table ('look-up-table') and FK constraint Charles Hauser
- Re: Use of reference table ('look-up-table') and FK constraint Stephan Szabo
- Re: Use of reference table ('look-up-table') and FK constraint Josh Berkus
- Quick contraint question Vincent Stoessel
- Help with SQL Eric L. Blevins
- Re: Help with SQL Oliver Elphick
- Re: Help with SQL Eric L. Blevins
- Re: Slow performance on MAX(primary_key) Keith Gray
- Re: Slow performance on MAX(primary_key) Charles H. Woloszynski
- getting the current date Joseph Syjuco
- Re: getting the current date Bruce Momjian
- Re: replace null with 0 in subselect ? Tom Lane
- Re: getting the current date Ludwig Lim
- Re: Slow performance on MAX(primary_key) Richard Huxton
- Re: functions that return a dataset or set of rows Gaetano Mendola
- Re: Use of reference table ('look-up-table') and FK constraint Charles Hauser
- object oriented vs relational DB Charles Hauser
- Re: Use of reference table ('look-up-table') and FK constraint Stephan Szabo
- Re: object oriented vs relational DB Josh Berkus
- Re: object oriented vs relational DB Richard Huxton
- Re: Messy Casts, Is there a better way? Larry Rosenman
- Re: Messy Casts, Is there a better way? Josh Berkus
- Re: Messy Casts, Is there a better way? Larry Rosenman
- Can I create working trigger on view Акулов Александр
- Re: Can I create working trigger on view Josh Berkus
- Apparent referential integrity bug in PL/pgSQL Brian Blaha
- UPDATE: Apparent referential integrity bug in PL/pgSQL Brian Blaha
- Re: Locking that will delayed a SELECT Christoph Haller
- Re: Locking that will delayed a SELECT Achilleus Mantzios
- Re: Locking that will delayed a SELECT Achilleus Mantzios
- TRIGGERed INSERTS Martin Crundall
- Re: Can I create working trigger on view Tom Lane
- Re: Locking that will delayed a SELECT Tom Lane
- Re: TRIGGERed INSERTS Tom Lane
- Re: Locking that will delayed a SELECT Ludwig Lim
- Re: Apparent referential integrity bug in PL/pgSQL Stephan Szabo
- Re: TRIGGERed INSERTS Martin Crundall
- Is there anyway to do this? Wei Weng
- Re: Is there anyway to do this? Bruno Wolff III
- triggers Stian Riis
- error...what to do? George
- hi lz John
- John Geng
- Re: date wishy wishy
- isAutoIncrement and Postgres john@eagleinfosystems.com (jm)
- Re: Is there anyway to do this? Ian Harding
- TRIGGERed INSERTS Martin Crundall
- Re: object oriented vs relational DB Marten Feldtmann
- Re: functions that return a dataset or set of rows Brian
- Re: [pgadmin-support] hi Hepworth, Mike
- Can I create working trigger on view Акулов Александр
- help! John Geng
- How to create secondary key!! Nelson Yong
- Re: foreign keys again wishy wishy
- Can I search for an array in csf? Vernon Wu
- Re: error...what to do? Andrew Perrin
- functions that return a dataset or set of rows Brian Ward
- foreign key, create table, and transactions Jeffrey Green
- Re: error...what to do? Stephan Szabo
- Re: functions that return a dataset or set of rows Bruce Momjian
- Re: triggers Bruce Momjian
- Re: Locking that will delayed a SELECT Tom Lane
- Re: isAutoIncrement and Postgres Josh Berkus
- Re: foreign key, create table, and transactions Stephan Szabo
- Re: date Jean-Luc Lachance
- Re: isAutoIncrement and Postgres Jean-Luc Lachance
- join question Frank Morton
- Re: date Tom Lane
- Re: join question Stephan Szabo
- Re: join question Jean-Luc Lachance
- adding column with not null constraint Vivek Khera
- Re: adding column with not null constraint
- Re: functions that return a dataset or set of rows Roberto Mello
- Restricting a VIEW. Terry Yapt
- Re: indexing on char vs varchar Bruce Momjian
- Re: adding column with not null constraint Johannes Lochmann
- Re: Restricting a VIEW. Ludwig Lim
- Re: Restricting a VIEW. Terry Yapt
- Re: Can I search for an array in csf? Richard Huxton
- Select table from other database Tiago Moitinho
- Re: isAutoIncrement and Postgres john@eagleinfosystems.com (jm)
- Re: isAutoIncrement and Postgres john@eagleinfosystems.com (jm)
- Re: Restricting a VIEW. Terry Yapt
- Re: Select table from other database Roberto Mello
- Re: isAutoIncrement and Postgres Josh Berkus
- Delete/Replace Bug in Functions? Josh Berkus
- Re: Delete/Replace Bug in Functions? Tom Lane
- Re: Delete/Replace Bug in Functions? Josh Berkus
- Row Locking? eric soroos
- Fwd: Re: Can I search for an array in csf? Vernon Wu
- Re: Fwd: Re: Can I search for an array in csf? Josh Berkus
- Re: Fwd: Re: Can I search for an array in csf? Achilleus Mantzios
- Re: Fwd: Re: Can I search for an array in csf? Achilleus Mantzios
- 'next' or similar in plpgsql Bhuvan A
- Re: Locking that will delayed a SELECT Ludwig Lim
- Re: Row Locking? Richard Huxton
- Re: Fwd: Re: Can I search for an array in csf? Vernon Wu
- 7.2 date/time format function problems Nicholas Barthelemy
- using deferred on PK/FK relationships Dan Langille
- Re: 7.2 date/time format function problems Stephan Szabo
- Re: using deferred on PK/FK relationships Stephan Szabo
- 'fake' join and performance ? Peter Galbavy
- Re: Can I search for an array in csf? Josh Berkus
- Re: Can I search for an array in csf? Vernon Wu
- Re: 'fake' join and performance ? Stephan Szabo
- Re: 'fake' join and performance ? Tom Lane
- Re: 'fake' join and performance ? Peter Galbavy
- sub-select with aggregate Tomasz Myrta
- 7.2 time format funtion issue Nicholas Barthelemy
- Re: 7.2 date/time format function problems Ian Harding
- Finding table constraints Jadcharla Srinivas
- Joining tables from different relational databases with AlligatorDBC webmaster@alligatorsql.de (www.alligatorsql.com)
- Multiple Databases peter
- Re: sub-select with aggregate Stephan Szabo
- Re: 7.2 time format funtion issue Tomasz Myrta
- Re: sub-select with aggregate Tomasz Myrta
- problem with a query Carlos Sousa
- Re: sub-select with aggregate Stephan Szabo
- Re: problem with a query Tomasz Myrta
- Re: sub-select with aggregate Tomasz Myrta
- Re: sub-select with aggregate Stephan Szabo
- Re: sub-select with aggregate Stephan Szabo
- Re: sub-select with aggregate Tomasz Myrta
- Re: sub-select with aggregate Stephan Szabo
- Re: Multiple Databases Josh Berkus
- Re: Multiple Databases Joe Conway
- odbc drivers andres javier garcia garcia
- plpgsql cursors : dynamic or static? Ludwig Lim
- Re: odbc drivers jasiek
- Re: odbc drivers Tomasz Myrta
- Hairy question - transpose columns andres javier garcia garcia
- Re: Hairy question - transpose columns Stephan Szabo
- Re: Hairy question - transpose columns eric soroos
- Re: plpgsql cursors : dynamic or static? Josh Berkus
- Re: plpgsql cursors : dynamic or static? Tom Lane
- Sum of Every Column Tom Haddon
- Sum of Every Column Tom Haddon
- Re: Sum of Every Column Jean-Luc Lachance
- Re: Sum of Every Column Josh Berkus
- sub-select trouble: wrong SQL or PostgreSQL issue? patrick
- Re: sub-select trouble: wrong SQL or PostgreSQL issue? Stephan Szabo
- Re: sub-select trouble: wrong SQL or PostgreSQL issue? Tom Lane
- Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement Ludwig Lim
- Re: sub-select with aggregate Tomasz Myrta
- Re: Sum of Every Column Achilleus Mantzios
- Re: 'next' or similar in plpgsql Christoph Haller
- Basic question. andres javier garcia garcia
- Re: Basic question. Tomasz Myrta
- Re: Basic question. Tomasz Myrta
- Re: sub-select trouble: wrong SQL or PostgreSQL issue? patrick
- Re: sub-select with aggregate Tomasz Myrta
- Re: sub-select with aggregate Tomasz Myrta
- Problems with to_char(created, 'WW') Andreas Joseph Krogh
- ORDER the result of a query by date andres javier garcia garcia
- Re: Problems with to_char(created, 'WW') Karel Zak
- Re: Problems with to_char(created, 'WW') Tomasz Myrta
- Re: ORDER the result of a query by date Achilleus Mantzios
- Re: Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement Tom Lane
- Help on creating a High Availability PostgreSQL solution? Charles H. Woloszynski
- from postgres to oracle Carlos Sousa
- Re: sub-select with aggregate Stephan Szabo
- redirect query results to my (stdout) screen andres javier garcia garcia
- Re: sub-select with aggregate Tomasz Myrta
- Re: redirect query results to my (stdout) screen Achilleus Mantzios
- Re: sub-select with aggregate Stephan Szabo
- Re: sub-select with aggregate Tom Lane
- High Availability PostgreSQL solution? Charles H. Woloszynski
- Re: Help on creating a High Availability PostgreSQL Tatsuo Ishii
- Re: ORDER the result of a query by date Henshall, Stuart - Design & Print
- Re: help! Horst Herb
- if exists (select * from ... Christoph Haller
- Re: Multiple Databases peter
- How can I retrieve an info about function arguments ? Zuev Dmitry
- grouping and first() peter
- Re: from postgres to oracle Thomas Good
- Upper / lower cases on table and column names Reiner Dassing
- Re: Upper / lower cases on table and column names Achilleus Mantzios
- Re: Upper / lower cases on table and column names Stephan Szabo
- Foreign character struggles Tim Perdue
- Re: Foreign character struggles Tom Lane
- Re: Foreign character struggles Roberto Mello
- Re: Foreign character struggles Tom Lane
- Re: grouping and first() Chad Thompson
- Re: Foreign character struggles Tim Perdue
- Re: Foreign character struggles Tom Lane
- Re: Foreign character struggles Tim Perdue
- Re: datediff? Josh Berkus
- Re: datediff? Josh Berkus
- Accumulated sums in SQL query Kabai József
- Re: Accumulated sums in SQL query Christoph Haller
- Re: Accumulated sums in SQL query Kabai József
- Re: Accumulated sums in SQL query Christoph Haller
- VACUUM and locking Denise Bossarte
- CoreReader John Ragan
- Re: Foreign character struggles Tony Grant
- subscrip out of range peter
- multiple databases peter
- Re: Hairy question - transpose columns mark carew
- Re: multiple databases Roberto Mello
- Re: CoreReader Roberto Mello
- Re: Accumulated sums in SQL query Kabai József
- Re: Accumulated sums in SQL query Marek Bartnikowski
- Re: VACUUM and locking Tom Lane
- psql history marnaudo@inwind.it
- Re: subscrip out of range Chad Thompson
- BOOLEAN question Josh Berkus
- Re: BOOLEAN question Stephan Szabo
- Re: BOOLEAN question Josh Berkus
- Re: BOOLEAN question Stephan Szabo
- Re: CoreReader John Ragan
- Creating Stored Procedures Philip Van Hoof
- Re: BOOLEAN question Tom Lane
- Re: Creating Stored Procedures Stephan Szabo
- Re: celko nested set functions greg@turnstep.com
- Re: BOOLEAN question Josh Berkus
- Re: BOOLEAN question Peter Eisentraut
- Selecting * from the base table but getting the inheriteds columns James Adams
- Re: BOOLEAN question Bruno Wolff III
- Database Design tool Viacheslav N Tararin
- Re: Selecting * from the base table but getting the inheriteds Tomasz Myrta
- Re: Creating Stored Procedures Kabai József
- Re: Database Design tool Bhuvan A
- Re: Creating Stored Procedures Jonas Wouters
- Re: Selecting * from the base table but getting the inheriteds James Adams
- Re: Database Design tool Tomasz Myrta
- Re: Creating Stored Procedures Adam Witney
- Re: Database Design tool Johannes Lochmann
- Re: Database Design tool Dan Hrabarchuk
- Re: BOOLEAN question Jean-Luc Lachance
- Re: BOOLEAN question Jean-Luc Lachance
- unnecessary updates chester c young
- Re: unnecessary updates Andrew Perrin
- How do I get rid of these messages? Wei Weng
- Re: Database Design tool Kevin Old
- Re: Database Design tool Wei Weng
- Re: Database Design tool Josh Berkus
- Re: Database Design tool Wei Weng
- Re: Database Design tool Josh Berkus
- time limit of a database connection jack
- Re: time limit of a database connection Achilleus Mantzios
- Re: How do I get rid of these messages? Bhuvan A
- Re: psql history Robert Treat
- Returning a recordset and filling datatable in a .NET applicatio n Jonas Wouters
- Re: Returning a recordset and filling datatable in a .NET Achilleus Mantzios
- How do you write this query? Wei Weng
- Re: How do you write this query? Richard Huxton
- Re: How do you write this query? Jean-Luc Lachance