db.postgresql.sql (date)

Download Firefox: Windows, Mac OS X

db.postgresql.sql (date)

October 31, 2002

Re: How do you write this query?, Jean-Luc Lachance
Re: How do you write this query?, Richard Huxton
How do you write this query?, Wei Weng
Re: Returning a recordset and filling datatable in a .NET, Achilleus Mantzios
Returning a recordset and filling datatable in a .NET applicatio n, Jonas Wouters
Re: psql history, Robert Treat
Re: How do I get rid of these messages?, Bhuvan A
Re: time limit of a database connection, Achilleus Mantzios
time limit of a database connection, jack

October 30, 2002

Re: Database Design tool, Josh Berkus
Re: Database Design tool, Wei Weng
Re: Database Design tool, Josh Berkus
Re: Database Design tool, Wei Weng
Re: Database Design tool, Kevin Old
How do I get rid of these messages?, Wei Weng
Re: unnecessary updates, Andrew Perrin
unnecessary updates, chester c young
Re: BOOLEAN question, Jean-Luc Lachance
Re: BOOLEAN question, Jean-Luc Lachance
Re: Database Design tool, Dan Hrabarchuk
Re: Database Design tool, Johannes Lochmann
Re: Database Design tool, Diogo Biazus
Re: Creating Stored Procedures, Adam Witney
Re: Database Design tool, Tomasz Myrta
Re: Selecting * from the base table but getting the inheriteds, James Adams
Re: Creating Stored Procedures, Jonas Wouters
Re: Database Design tool, Bhuvan A
Re: Creating Stored Procedures, Kabai József
Re: Selecting * from the base table but getting the inheriteds, Tomasz Myrta
Database Design tool, Viacheslav N Tararin
Re: BOOLEAN question, Bruno Wolff III

October 29, 2002

Selecting * from the base table but getting the inheriteds columns, James Adams
Re: BOOLEAN question, Peter Eisentraut
Re: BOOLEAN question, Josh Berkus
Re: celko nested set functions, greg
Re: Creating Stored Procedures, Stephan Szabo
Re: BOOLEAN question, Tom Lane
Creating Stored Procedures, Philip Van Hoof
Re: CoreReader, John Ragan
Re: BOOLEAN question, Stephan Szabo
Re: BOOLEAN question, Josh Berkus
Re: BOOLEAN question, Stephan Szabo
BOOLEAN question, Josh Berkus

October 28, 2002

Re: subscrip out of range, Chad Thompson
psql history, marnaudo@xxxxxxxxx
Re: VACUUM and locking, Tom Lane
Re: Accumulated sums in SQL query, Marek Bartnikowski
Re: Accumulated sums in SQL query, Kabai József
Re: CoreReader, Roberto Mello
Re: multiple databases, Roberto Mello
Re: Hairy question - transpose columns, mark carew
multiple databases, peter
subscrip out of range, peter
Re: Foreign character struggles, Tony Grant
CoreReader, John Ragan
VACUUM and locking, Denise Bossarte
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
Accumulated sums in SQL query, Kabai József

October 27, 2002

Re: datediff?, Josh Berkus
Re: datediff?, Josh Berkus

October 26, 2002

Re: How can I retrieve an info about function arguments ?, Bhuvan A

October 25, 2002

Re: Foreign character struggles, Tim Perdue
Re: Foreign character struggles, Tom Lane
Re: Foreign character struggles, Tim Perdue
Re: grouping and first(), Chad Thompson
Re: Foreign character struggles, Tom Lane
Re: Foreign character struggles, Roberto Mello
Re: Foreign character struggles, Tom Lane
Foreign character struggles, Tim Perdue
Re: Upper / lower cases on table and column names, Stephan Szabo
Re: Upper / lower cases on table and column names, Achilleus Mantzios
Upper / lower cases on table and column names, Reiner Dassing
Re: from postgres to oracle, Thomas Good
How can I retrieve an info about function arguments ?, Zuev Dmitry
Re: Multiple Databases, peter
grouping and first(), peter
if exists (select * from ..., Christoph Haller
Re: help!, Horst Herb
Re: ORDER the result of a query by date, Henshall, Stuart - Design & Print
Re: Help on creating a High Availability PostgreSQL, Tatsuo Ishii
High Availability PostgreSQL solution?, Charles H. Woloszynski

October 24, 2002

Re: sub-select with aggregate, Tom Lane
Re: sub-select with aggregate, Stephan Szabo
Re: redirect query results to my (stdout) screen, Achilleus Mantzios
Re: sub-select with aggregate, Tomasz Myrta
redirect query results to my (stdout) screen, andres javier garcia garcia
Re: sub-select with aggregate, Stephan Szabo
from postgres to oracle, Carlos Sousa
Help on creating a High Availability PostgreSQL solution?, Charles H. Woloszynski
Re: Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement, Tom Lane
Re: ORDER the result of a query by date, Achilleus Mantzios
Re: Problems with to_char(created, 'WW'), Tomasz Myrta
Re: Problems with to_char(created, 'WW'), Karel Zak
ORDER the result of a query by date, andres javier garcia garcia
Problems with to_char(created, 'WW'), Andreas Joseph Krogh
Re: sub-select with aggregate, Tomasz Myrta
Re: sub-select with aggregate, Tomasz Myrta
Re: sub-select trouble: wrong SQL or PostgreSQL issue?, patrick
Re: Basic question., Tomasz Myrta
Re: Basic question., Tomasz Myrta
Basic question., andres javier garcia garcia
Re: 'next' or similar in plpgsql, Christoph Haller
Re: Sum of Every Column, Achilleus Mantzios
Re: sub-select with aggregate, Tomasz Myrta
Simulating a SELECT..FOR UPDATE to LOCK and SELECT statement, Ludwig Lim
Re: sub-select trouble: wrong SQL or PostgreSQL issue?, Tom Lane
Re: sub-select trouble: wrong SQL or PostgreSQL issue?, Stephan Szabo
sub-select trouble: wrong SQL or PostgreSQL issue?, patrick

October 23, 2002

Re: Sum of Every Column, Josh Berkus
Re: Sum of Every Column, Jean-Luc Lachance
Sum of Every Column, Tom Haddon
Sum of Every Column, Tom Haddon
Re: plpgsql cursors : dynamic or static?, Tom Lane
Re: plpgsql cursors : dynamic or static?, Josh Berkus
Re: Hairy question - transpose columns, eric soroos
Re: Hairy question - transpose columns, Stephan Szabo
Hairy question - transpose columns, andres javier garcia garcia
Re: odbc drivers, Tomasz Myrta
Re: odbc drivers, jasiek
plpgsql cursors : dynamic or static?, Ludwig Lim
odbc drivers, andres javier garcia garcia
Re: sub-select with aggregate, Tomasz Myrta
Re: Multiple Databases, Joe Conway
Re: Multiple Databases, Josh Berkus
Re: sub-select with aggregate, Stephan Szabo
Re: sub-select with aggregate, Stephan Szabo
Re: sub-select with aggregate, Stephan Szabo
Re: sub-select with aggregate, Tomasz Myrta
Re: problem with a query, Tomasz Myrta
Re: sub-select with aggregate, Stephan Szabo
problem with a query, Carlos Sousa
Re: sub-select with aggregate, Tomasz Myrta
Re: 7.2 time format funtion issue, Tomasz Myrta
Re: sub-select with aggregate, Stephan Szabo
Multiple Databases, peter
Joining tables from different relational databases with AlligatorDBC, www.alligatorsql.com
7.2 time format funtion issue, Nicholas Barthelemy
Finding table constraints, Jadcharla Srinivas
Re: 7.2 date/time format function problems, Ian Harding
sub-select with aggregate, Tomasz Myrta

October 22, 2002

Re: 'fake' join and performance ?, Peter Galbavy
Re: 'fake' join and performance ?, Tom Lane
Re: 'fake' join and performance ?, Stephan Szabo
Re: Can I search for an array in csf?, Vernon Wu
Re: Can I search for an array in csf?, Josh Berkus
'fake' join and performance ?, Peter Galbavy
Re: using deferred on PK/FK relationships, Stephan Szabo
Re: 7.2 date/time format function problems, Stephan Szabo
using deferred on PK/FK relationships, Dan Langille
7.2 date/time format function problems, Nicholas Barthelemy
Re: Fwd: Re: Can I search for an array in csf?, Vernon Wu
Re: Row Locking?, Richard Huxton
Re: Locking that will delayed a SELECT, Ludwig Lim
'next' or similar in plpgsql, Bhuvan A
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
Re: Fwd: Re: Can I search for an array in csf?, Josh Berkus
Fwd: Re: Can I search for an array in csf?, Vernon Wu

October 21, 2002

Row Locking?, eric soroos
Re: Delete/Replace Bug in Functions?, Josh Berkus
Re: Delete/Replace Bug in Functions?, Tom Lane
Delete/Replace Bug in Functions?, Josh Berkus
Re: isAutoIncrement and Postgres, Josh Berkus
Re: Select table from other database, Roberto Mello
Re: Restricting a VIEW., Terry Yapt
Re: isAutoIncrement and Postgres, jm
Re: isAutoIncrement and Postgres, jm
Select table from other database, Tiago Moitinho
Re: Can I search for an array in csf?, Richard Huxton
Re: Restricting a VIEW., Terry Yapt
Re: Restricting a VIEW., Ludwig Lim

October 20, 2002

Re: adding column with not null constraint, Johannes Lochmann
Re: indexing on char vs varchar, Bruce Momjian
Restricting a VIEW., Terry Yapt

October 18, 2002

Re: functions that return a dataset or set of rows, Roberto Mello
Re: adding column with not null constraint, mallah
adding column with not null constraint, Vivek Khera
Re: join question, Jean-Luc Lachance
Re: join question, Stephan Szabo
Re: date, Tom Lane
join question, Frank Morton
Re: date, Jean-Luc Lachance
Re: isAutoIncrement and Postgres, Jean-Luc Lachance
Re: foreign key, create table, and transactions, Stephan Szabo
Re: isAutoIncrement and Postgres, Josh Berkus
Re: functions that return a dataset or set of rows, Bruce Momjian
Re: Locking that will delayed a SELECT, Tom Lane
Re: triggers, Bruce Momjian
Re: error...what to do?, Stephan Szabo
foreign key, create table, and transactions, Jeffrey Green
functions that return a dataset or set of rows, Brian Ward
Re: error...what to do?, Andrew Perrin
Can I search for an array in csf?, Vernon Wu
isAutoIncrement and Postgres, jm
How to create secondary key!!, Nelson Yong
error...what to do?, George
Re: date, wishy wishy
hi, lz John
Re: foreign keys again, wishy wishy
help!, John Geng
(unknown), John Geng
triggers, Stian Riis
Can I create working trigger on view, Акулов Александр
Re: [pgadmin-support] hi, Hepworth, Mike
Re: functions that return a dataset or set of rows, Brian
Re: object oriented vs relational DB, Marten Feldtmann
TRIGGERed INSERTS, Martin Crundall
Re: Is there anyway to do this?, Ian Harding
Re: Is there anyway to do this?, Bruno Wolff III
Is there anyway to do this?, Wei Weng
Re: TRIGGERed INSERTS, Martin Crundall
Re: Apparent referential integrity bug in PL/pgSQL, Stephan Szabo
Re: Locking that will delayed a SELECT, Ludwig Lim
Re: TRIGGERed INSERTS, Tom Lane
Re: Locking that will delayed a SELECT, Tom Lane
Re: Can I create working trigger on view, Tom Lane
TRIGGERed INSERTS, Martin Crundall
Re: Locking that will delayed a SELECT, Achilleus Mantzios
Re: Locking that will delayed a SELECT, Achilleus Mantzios
Re: Locking that will delayed a SELECT, Christoph Haller
UPDATE: Apparent referential integrity bug in PL/pgSQL, Brian Blaha
Apparent referential integrity bug in PL/pgSQL, Brian Blaha
Re: Can I create working trigger on view, Josh Berkus
Can I create working trigger on view, Acue
Re: Messy Casts, Is there a better way?, Larry Rosenman

October 17, 2002

Re: Messy Casts, Is there a better way?, Josh Berkus
Re: Messy Casts, Is there a better way?, Larry Rosenman
Re: object oriented vs relational DB, Richard Huxton
Re: object oriented vs relational DB, Josh Berkus
Re: Use of reference table ('look-up-table') and FK constraint, Stephan Szabo
object oriented vs relational DB, Charles Hauser
Re: Use of reference table ('look-up-table') and FK constraint, Charles Hauser
Re: functions that return a dataset or set of rows, Gaetano Mendola
Re: Slow performance on MAX(primary_key), Richard Huxton
Re: getting the current date, Ludwig Lim
Re: replace null with 0 in subselect ?, Tom Lane
Re: getting the current date, Bruce Momjian
getting the current date, Joseph Syjuco
Re: Slow performance on MAX(primary_key), Charles H. Woloszynski
Re: Slow performance on MAX(primary_key), Keith Gray

October 16, 2002

Re: Help with SQL, Eric L. Blevins
Re: Help with SQL, Oliver Elphick
Help with SQL, Eric L. Blevins
Quick contraint question, Vincent Stoessel
Re: Use of reference table ('look-up-table') and FK constraint, Josh Berkus
Re: Use of reference table ('look-up-table') and FK constraint, Stephan Szabo
Use of reference table ('look-up-table') and FK constraint, Charles Hauser
Re: replace null with 0 in subselect ?, Stephan Szabo
Re: set difference, Tom Lane
Re: set difference, Domoszlai László
pg_atoi() error, alexandre :: aldeia digital
Re: replace null with 0 in subselect ?, Ian Barwick
Locking that will delayed a SELECT, Ludwig Lim
replace null with 0 in subselect ?, Albrecht Berger
Re: SQL function triggers, Jan Wieck

October 15, 2002

Re: int id's helpful for indexing, or just use text names?, Tom Lane
ADO with postgreSQL, 2000 Informática
int id's helpful for indexing, or just use text names?, george young
Re: Messy Casts, Is there a better way?, Peter Eisentraut
Re: Messy Casts, Is there a better way?, Josh Berkus
Re: set difference, Tom Lane
Re: how do i insert an empty string ?, Jeff
Re: SQL function triggers, Tom Lane
Re: Stored procedure returning row or resultset, Tom Lane
set difference, Domoszlai László
Messy Casts, Is there a better way?, Larry Rosenman
Re: IGNORE ME how do i insert an empty string ?, Peter Galbavy
Re: how do i insert an empty string ?, Peter Galbavy
how do i insert an empty string ?, Peter Galbavy
Re: Stored procedure returning row or resultset, Richard Huxton
Re: Slow performance on MAX(primary_key), Richard Huxton
Re: Slow performance on MAX(primary_key), Keith Gray
Re: Slow performance on MAX(primary_key), Ludwig Lim
SQL function triggers, Brian Blaha
Slow performance on MAX(primary_key), Keith Gray

October 14, 2002

Re: Stored procedure returning row or resultset, Tom Lane
Re: Stored procedure returning row or resultset, Richard Huxton
Re: Stored procedure returning row or resultset, Brian Blaha
Stored procedure returning row or resultset, Heiko Stoermer

October 12, 2002

Re: DELETE command is getting blocked, Stephan Szabo
DELETE command is getting blocked, Bhuvan A

October 11, 2002

Missing Review, Josh Berkus
Re: triggers, Achilleus Mantzios
Re: triggers, Richard Huxton
triggers, Stian Riis
Re: NOTICE: generated by sequence nextval(), Thrasher
Re: NOTICE: generated by sequence nextval(), Michael Ansley (UK)

October 10, 2002

(unknown), Luis Mix
NOTICE: generated by sequence nextval(), John Duffy
Re: SELECT with INNER data bases, Roberto Mello
Re: SELECT with INNER data bases, Bruno Wolff III
SELECT with INNER data bases, 2000 Informática
Re: SQL Error, Achilleus Mantzios
Re: SQL Error, Christoph Haller
Re: Viewing stored procedure code, Achilleus Mantzios
Viewing stored procedure code, Ludwig Lim

October 09, 2002

Re: foreign key problem, Laurette Cisneros
Re: problem with the Index, Stephan Szabo
Re: SELECT statement never completes., Stephan Szabo
SELECT statement never completes., John Pauley
problem with the Index, Jose Antonio Leo
Re: Complex SQL query and performance strategy, Tom Lane
Complex SQL query and performance strategy, Adam Witney
Re: PLPGSQL errors, Richard Huxton
PLPGSQL errors, Rudi Starcevic
Re: Problems Formulating a SELECT, Richard Huxton
Re: Temporary tables and indexes, Josh Berkus
Re: Temporary tables and indexes, Tom Lane
Re: IN, EXISTS or ANY?, Josh Berkus
Re: IN, EXISTS or ANY?, Keith Gray
Table Rule, Rudi Starcevic

October 08, 2002

Re: Problems Formulating a SELECT, Charles Hauser
Re: Problems Formulating a SELECT, Richard Huxton
Re: Temporary tables and indexes, Ian Harding
Re: How slow is distinct - 2nd, Michael Contzen
Re: [NOVICE] update question, Josh Berkus
Re: Temporary tables and indexes, Josh Berkus
Re: Problems Formulating a SELECT, Charles Hauser
Re: foreign key, on delete cascade..., Stephan Szabo
foreign key, on delete cascade..., Mathieu Arnold
Re: Probs "compiling" a function, Richard Huxton
Re: Problems Formulating a SELECT, Richard Huxton
Temporary tables and indexes, Ludwig Lim
Probs "compiling" a function, gordoncl
Re: foreign key problem, Stephan Szabo
Re: foreign key problem, Josh Berkus
Re: foreign key problem, Josh Berkus
foreign key problem, Laurette Cisneros

October 07, 2002

SQL Error, Rafal Kedziorski
Debug information, Rafal Kedziorski
Problems Formulating a SELECT, Charles Hauser
Re: Get A Tree from a table, Joe Conway
Re: Get A Tree from a table, Josh Berkus
Re: enforcing with unique indexes.., Jean-Luc Lachance
Re: timestamp, Dan Langille
Re: timestamp, Dan Langille
Re: Need some SQL help, Dan Langille
Re: timestamp, Larry Rosenman
Get A Tree from a table, Scott Yaung
sum function, Dagoberto Torres
timestamp, Brian Ward
Re: timestamp, Brian Ward
Need some SQL help, Brian Ward

October 06, 2002

Re: Suggestion: md5/crypt functions in sql, Dan Langille
Re: Suggestion: md5/crypt functions in sql, Joe Conway
Re: problem with subqueries, Stephan Szabo
Suggestion: md5/crypt functions in sql, Aasmund Midttun Godal
Re: problem with subqueries, pete
Re: problem with subqueries, Stephan Szabo
Re: problem with subqueries, Tom Lane

October 05, 2002

problem with subqueries, pete
Re: enforcing with unique indexes.., dev
Re: enforcing with unique indexes.., Rajesh Kumar Mallah.
enforcing with unique indexes.., Rajesh Kumar Mallah.

October 04, 2002

Self Join?, bens_nospam
Re: [SQL] arrays, scott.marlowe
Re: rows in order, Joe Conway
Re: Can Postgres cache a table in memory?, Josh Berkus
Re: rows in order, Oleg Bartunov
Re: How slow is distinct - 2nd, Bruno Wolff III
Re: How slow is distinct - 2nd, Tom Lane
Re: Rule creation, Tom Lane
Re: Can Postgres cache a table in memory?, Tom Lane
Re: rows in order, Richard Huxton
Re: Can Postgres cache a table in memory?, Richard Huxton
Re: please help with converting a view in oracle into postgresql readably code, Tom Lane
Re: rows in order, Achilleus Mantzios
Re: Can Postgres cache a table in memory?, Achilleus Mantzios
Rule creation, Edoardo Causarano
How slow is distinct - 2nd, Michael Contzen
Can Postgres cache a table in memory?, Kevin Traub
rows in order, Camila Rocha
please help with converting a view in oracle into postgresql readably code, Matthew Geddert
Re: order by x DESC, y ASC indexing problem, Tom Lane
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, Josh Berkus
order by x DESC, y ASC indexing problem, Vincent-Olivier Arsenault

October 03, 2002

Re: drop constraint primary key, Tom Lane
drop constraint primary key, Marie G. Tuite
Re: epoch to date, Achilleus Mantzios
Re: Formatting current_time output, Karel Zak
Re: Formatting current_time output, Thomas Good
Re: Formatting current_time output, Charles H. Woloszynski
Re: Formatting current_time output, Achilleus Mantzios
Re: Formatting current_time output, Josh Berkus
epoch to date, Roberto Mello
Formatting current_time output, Thomas Good
Re: Updating from select, Thrasher
Re: split function for pl/pgsql, Joe Conway

October 02, 2002

Re: celko nested set functions, Josh Berkus
Re: schedule of v7.3, Bruce Momjian
celko nested set functions, Robert Treat
schedule of v7.3, Jie Liang
Re: Stored Procedures, Joe Conway
Re: indexing on char vs varchar, Beth Gatewood
Re: Stored Procedures, david williams
Re: indexing on char vs varchar, Josh Berkus
Re: Stored Procedures, bcschnei
Re: indexing on char vs varchar, Josh Berkus
Re: Updating from select, Manfred Koizar
Re: indexing on char vs varchar, Beth Gatewood
Updating from select, Thrasher
Re: indexing on char vs varchar, Bruce Momjian
Re: split function for pl/pgsql, Frederic Logier
indexing on char vs varchar, Beth Gatewood
Re: Stored Procedures, Joe Conway
Re: split function for pl/pgsql, Joe Conway
Re: Stored Procedures, david williams
Re: Stored Procedures, david williams
Re: PROBLEM SOLVED RE: please help with converting a view in oracle into postgresql readably code, Roberto Mello
split function for pl/pgsql, Frederic Logier
Re: please help with converting a view in oracle into postgresql readably code, Roberto Mello
please help with converting a view in oracle into postgresql readably code, mgeddert

October 01, 2002

Re: Stored Procedures, Roberto Mello
Stored Procedures, bcschnei
Re: [GENERAL] arrays, Josh Berkus
Re: [GENERAL] arrays, Roland Roberts
Re: alter user does not changes password, Tom Lane
Re: alter user does not changes password, dima
alter user does not changes password, Lucas Brasilino
Re: [SQL] arrays, Achilleus Mantzios

^^^ ADDITIONAL NAVIGATION ^^^

Recently Viewed:
emacs.dvc.devel... java.displaytag... ietf.rfc822/199... linux.altlinux.... redhat.fedora.r... python.ctypes/2... video.panorama/... freedesktop.xor... audio.emagic.lo... netbsd.devel.us... documentation.t... yellowdog.gener... gnome.mono.mono... bacula.user/200... shells.bash.bug... xfree86.devel/2... culture.bicycle... mozilla.devel.n... web.squid.gener... user-groups.gul... kde.amarok.bugs... org.user-groups... handhelds.linux... tex.context/200...

Home | blog view, Court Document Archive | USPTO Patent Archive (NEW!) | advertise | OSDir is an inevitable website. super tiny logo