pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedgetting ILIKE or ~* to use indexes....
2002-08-10 06:13 UTC Rajesh Kumar Mallah. <mallah@trade-india.com>
` Re: getting ILIKE or ~* to use indexes....
2002-08-10 18:10 UTC Josh Berkus <josh@agliodbs.com>
` Re: getting ILIKE or ~* to use indexes....
2002-08-10 21:14 UTC mallah@trade-india.com
[3+ messages in thread]
retrieving all rows from a "tree" in one select - how ?
2002-08-09 21:36 UTC h012@ied.com
` Re: retrieving all rows from a "tree" in one select - how ?
2002-08-09 22:04 UTC Adam Erickson <adamre@cox.net>
` Re: retrieving all rows from a "tree" in one select - how ?
2002-08-09 22:15 UTC Josh Berkus <josh@agliodbs.com>
` Re: retrieving all rows from a "tree" in one select - how ?
2002-08-09 23:37 UTC Oleg Bartunov <oleg@sai.msu.su>
[4+ messages in thread]
How to update record in a specified order
2002-08-09 21:21 UTC Jean-Luc Lachance <jllachan@nsd.ca>
` Re: How to update record in a specified order
2002-08-09 21:37 UTC Josh Berkus <josh@agliodbs.com>
` Re: How to update record in a specified order
2002-08-09 21:59 UTC Jean-Luc Lachance <jllachan@nsd.ca>
` Re: How to update record in a specified order
2002-08-09 22:02 UTC Dan Langille <dan@langille.org>
` Re: How to update record in a specified order
2002-08-09 22:12 UTC Josh Berkus <josh@agliodbs.com>
[5+ messages in thread]
RE: SQL Syntax
1999-02-08 20:49 UTC Jackson, DeJuan <djackson@cpsgroup.com>
` SQL syntax
2002-07-31 13:16 UTC Mindaugas Riauba <mind@bi.lt>
` Re: SQL syntax
2002-07-31 15:57 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` SQL syntax
2002-08-06 15:29 UTC frederic massot <frederic@juliana-multimedia.com>
` Re: SQL syntax
2002-08-06 16:48 UTC Tod McQuillin <devin@spamcop.net>
` Re: SQL syntax
2002-08-06 17:10 UTC Cedric Dufour (Cogito Ergo Soft) <cedric.dufour@cogito-ergo-soft.com>
` Re: SQL syntax
2002-08-06 17:38 UTC Jean-Luc Lachance <jllachan@nsd.ca>
` Re: SQL syntax
2002-08-06 17:53 UTC Jean-Luc Lachance <jllachan@nsd.ca>
` Re: SQL syntax
2002-08-07 03:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL syntax
2002-08-07 03:47 UTC Bruno Wolff III <bruno@wolff.to>
` Re: SQL syntax
2002-08-09 21:36 UTC Jean-Luc Lachance <jllachan@nsd.ca>
[11+ messages in thread]
expressions operating on arrays
2002-08-09 04:38 UTC h012@ied.com
` Re: expressions operating on arrays
2002-08-09 06:17 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: expressions operating on arrays
2002-08-09 07:12 UTC h012@ied.com
` Re: expressions operating on arrays
2002-08-09 07:30 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: expressions operating on arrays
2002-08-09 13:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: expressions operating on arrays
2002-08-09 14:57 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: expressions operating on arrays
2002-08-09 20:49 UTC h012@ied.com
[7+ messages in thread]
Table Sorting and Limit Question
2002-08-08 20:10 UTC Dawn Hollingsworth <dmh@airdefense.net>
` Re: Table Sorting and Limit Question
2002-08-09 01:42 UTC Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: Table Sorting and Limit Question
2002-08-09 13:55 UTC Dawn Hollingsworth <dmh@airdefense.net>
[3+ messages in thread]
getting oid of an INSERT automatically
2002-08-07 18:39 UTC John Brothers <johnbr@undefined.com>
` Re: getting oid of an INSERT automatically
2002-08-08 13:28 UTC Oliver Elphick <olly@lfix.co.uk>
` Re: getting oid of an INSERT automatically
2002-08-08 19:18 UTC John Brothers <johnbr@undefined.com>
[3+ messages in thread]
looking to speed up SELECT ... LEFT JOIN query
2002-08-07 05:03 UTC Trey Ackerman <ta145@yahoo.com>
` Re: looking to speed up SELECT ... LEFT JOIN query
2002-08-08 14:24 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
manipulating the POINT data type
2002-08-07 17:16 UTC Floyd Shackelford <floyds@4peakstech.com>
` Re: manipulating the POINT data type
2002-08-08 13:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
to_char and '=' weirdness
2002-08-08 11:33 UTC Frank Joerdens <frank@joerdens.de>
` Re: to_char and '=' weirdness
2002-08-08 11:48 UTC Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: to_char and '=' weirdness
2002-08-08 12:11 UTC Karel Zak <zakkr@zf.jcu.cz>
` Re: to_char and '=' weirdness
2002-08-08 12:46 UTC Frank Joerdens <frank@joerdens.de>
` Re: to_char and '=' weirdness
2002-08-08 13:04 UTC Frank Joerdens <frank@joerdens.de>
[5+ messages in thread]
Altering live databases
2002-08-07 21:45 UTC Gregory Brauer <greg@wildbrain.com>
` Re: Altering live databases
2002-08-08 02:38 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Altering live databases
2002-08-08 02:52 UTC Gregory Brauer <greg@wildbrain.com>
` Re: Altering live databases
2002-08-08 02:59 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[4+ messages in thread]
ALTER TABLE follow up
2002-08-06 22:41 UTC Tom Haddon <tom@betterhealthfoundation.org>
` Re: ALTER TABLE follow up
2002-08-07 02:02 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: ALTER TABLE follow up
2002-08-07 18:30 UTC Tom Haddon <tom@betterhealthfoundation.org>
` Re: ALTER TABLE follow up
2002-08-08 02:32 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[4+ messages in thread]
running psql in a cron job
2002-08-07 14:51 UTC Wei Weng <wweng@kencast.com>
` Re: running psql in a cron job
2002-08-07 15:01 UTC Wei Weng <wweng@kencast.com>
` Re: running psql in a cron job
2002-08-07 17:07 UTC Wei Weng <wweng@kencast.com>
` Re: running psql in a cron job
2002-08-07 18:02 UTC Ignacio Coloma <icoloma-lists@iverdino.com>
` Re: running psql in a cron job
2002-08-07 18:54 UTC Ross J. Reedstrom <reedstrm@rice.edu>
[5+ messages in thread]
Table is modified?
2002-08-07 14:29 UTC Yuri Gordienko <iqsoft@cg.ukrtel.net>
control reaches end of trigger procedure without RETURN
2002-08-06 22:12 UTC rramostalo@quorum.com
` Re: control reaches end of trigger procedure without RETURN
2002-08-07 13:35 UTC Jeff Eckermann <jeff_eckermann@yahoo.com>
[2+ messages in thread]
Views/queries and optimal indexes usage (cf. planner)
2002-08-07 11:49 UTC Cédric Dufour <cedric.dufour@freesurf.ch>
Limit A Table To 1 Row
2002-08-07 03:29 UTC cnliou@eurosport.com
` Re: Limit A Table To 1 Row
2002-08-07 03:42 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Limit A Table To 1 Row
2002-08-07 03:52 UTC Josh Berkus <josh@agliodbs.com>
` Re: Limit A Table To 1 Row
2002-08-07 08:30 UTC Richard Huxton <dev@archonet.com>
[4+ messages in thread]
problem fetching currval of sequence
2002-08-06 15:14 UTC Charles Hauser <chauser@duke.edu>
` Re: problem fetching currval of sequence
2002-08-06 15:45 UTC Josh Berkus <josh@agliodbs.com>
` Re: problem fetching currval of sequence
2002-08-06 15:57 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: problem fetching currval of sequence
2002-08-06 16:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
2002-08-06 16:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
2002-08-06 16:43 UTC Charles Hauser <chauser@duke.edu>
` Re: problem fetching currval of sequence
2002-08-06 16:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
2002-08-06 18:35 UTC Josh Berkus <josh@agliodbs.com>
` Re: problem fetching currval of sequence
2002-08-06 20:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem fetching currval of sequence
2002-08-06 20:37 UTC Josh Berkus <josh@agliodbs.com>
` Re: problem fetching currval of sequence
2002-08-06 20:53 UTC Charles Hauser <chauser@duke.edu>
` Re: problem fetching currval of sequence
2002-08-06 21:26 UTC Josh Berkus <josh@agliodbs.com>
[12+ messages in thread]
Multi table insert and passing sequence ids
2002-08-06 12:55 UTC Norman Khine <norman@spot5.com>
` Re: Multi table insert and passing sequence ids
2002-08-06 17:38 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
Transitive Closure
2002-07-31 04:50 UTC Suhas Joshi <suhas@hotmail.com>
` Re: Transitive Closure
2002-08-06 14:06 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Transitive Closure
2002-08-06 14:59 UTC Dan Langille <dan@langille.org>
` Re: Transitive Closure
2002-08-06 15:28 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: Transitive Closure
2002-08-06 17:01 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Transitive Closure
2002-08-06 17:34 UTC Oleg Bartunov <oleg@sai.msu.su>
[6+ messages in thread]
Re: copy files to postgresql
2002-08-06 12:14 UTC John Zhang <jzhang@jimmy.harvard.edu>
` Re: copy files to postgresql
2002-08-06 13:23 UTC Jeff Eckermann <jeff_eckermann@yahoo.com>
` Re: copy files to postgresql
2002-08-06 14:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: copy files to postgresql
2002-08-06 16:20 UTC Jean-Luc Lachance <jllachan@nsd.ca>
[4+ messages in thread]
Concatenate aggregate?
2002-08-06 08:03 UTC Julian Scarfe <julian.scarfe@ntlworld.com>
` Re: Concatenate aggregate?
2002-08-06 08:28 UTC Archibald Zimonyi <archie@netg.se>
` Re: Concatenate aggregate?
2002-08-06 08:37 UTC Julian Scarfe <julian.scarfe@ntlworld.com>
[3+ messages in thread]
VACUUM not doing its job?
2002-08-03 20:53 UTC Kristian Eide <kreide@online.no>
` Re: VACUUM not doing its job?
2002-08-03 22:14 UTC Ken Corey <ken@kencorey.com>
` Re: VACUUM not doing its job?
2002-08-03 22:40 UTC Kristian Eide <kreide@online.no>
` Re: VACUUM not doing its job?
2002-08-03 22:59 UTC Sander Steffann <sander@steffann.nl>
` Re: VACUUM not doing its job?
2002-08-03 23:02 UTC Joe Conway <mail@joeconway.com>
` Re: VACUUM not doing its job?
2002-08-03 23:39 UTC Kristian Eide <kreide@online.no>
` Re: VACUUM not doing its job?
2002-08-04 00:32 UTC Joe Conway <mail@joeconway.com>
` Re: VACUUM not doing its job?
2002-08-04 11:22 UTC Jochem van Dieten <nomail@devnull.invalid>
` Re: VACUUM not doing its job?
2002-08-05 21:40 UTC Robert Treat <xzilla@users.sourceforge.net>
[9+ messages in thread]
Group And Sort After Union
2002-07-30 08:46 UTC cnliou <cnliou@eurosport.com>
` Re: Group And Sort After Union
2002-08-02 13:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Group And Sort After Union
2002-08-05 09:55 UTC Terry Yapt <yapt@technovell.com>
[3+ messages in thread]
Bug with dump/restore when using UNION and ORDER BY in views
2002-08-03 21:11 UTC Kristian Eide <kreide@online.no>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
2002-08-04 03:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
2002-08-04 05:24 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
2002-08-04 05:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
2002-08-04 05:54 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Bug with dump/restore when using UNION and ORDER BY in views
2002-08-04 06:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox