pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSql Query help: Remove Sub Selects
2005-07-10 23:20 UTC Rob <robo_spamcatcher_this_is_invalid_too@speakeasy.net>
Make COUNT(*) Faster?
2005-07-07 22:48 UTC Varun Mehta <vmehta@apple.com>
` Re: Make COUNT(*) Faster?
2005-07-08 02:21 UTC Michael Fuhr <mike@fuhr.org>
` Re: Make COUNT(*) Faster?
2005-07-08 03:39 UTC Chris Browne <cbbrowne@acm.org>
` Re: Make COUNT(*) Faster?
2005-07-08 04:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Make COUNT(*) Faster?
2005-07-08 14:12 UTC Steve Wampler <swampler@noao.edu>
` Re: Make COUNT(*) Faster?
2005-07-08 14:35 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Make COUNT(*) Faster?
2005-07-08 15:07 UTC Steve Wampler <swampler@noao.edu>
` Re: Make COUNT(*) Faster?
2005-07-08 15:22 UTC Rod Taylor <pg@rbt.ca>
` Re: Make COUNT(*) Faster?
2005-07-08 15:30 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: Make COUNT(*) Faster?
2005-07-08 15:31 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Make COUNT(*) Faster?
2005-07-08 15:34 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: Make COUNT(*) Faster?
2005-07-08 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Make COUNT(*) Faster?
2005-07-08 15:38 UTC Rod Taylor <pg@rbt.ca>
` Re: Make COUNT(*) Faster?
2005-07-08 16:00 UTC Steve Wampler <swampler@noao.edu>
` Re: Make COUNT(*) Faster?
2005-07-08 16:08 UTC PFC <lists@boutiquenumerique.com>
` Re: Make COUNT(*) Faster?
2005-07-08 16:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Make COUNT(*) Faster?
2005-07-08 17:08 UTC Steve Wampler <swampler@noao.edu>
` Re: Make COUNT(*) Faster?
2005-07-08 17:09 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Make COUNT(*) Faster?
2005-07-08 19:51 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Make COUNT(*) Faster?
2005-07-10 12:19 UTC Harald Fuchs <hf0614x@protecting.net>
` Re: Make COUNT(*) Faster?
2005-07-10 16:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
[21+ messages in thread]
Index creation question for expression (col1 || '-' || col2)
2005-07-08 16:08 UTC Ying Lu <ying_lu@cs.concordia.ca>
` Re: Index creation question for expression (col1 || '-' || col2)
2005-07-08 16:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index creation question for expression (col1 || '-' || col2)
2005-07-08 16:32 UTC Michael Fuhr <mike@fuhr.org>
` Re: Index creation question for expression (col1 || '-' || col2)
2005-07-08 16:57 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Index creation question for expression (col1 || '-' ||
2005-07-08 17:08 UTC Ying Lu <ying_lu@cs.concordia.ca>
[5+ messages in thread]
two sums in one query
2005-07-08 05:48 UTC Kenneth Gonsalves <lawgon@thenilgiris.com>
` Re: two sums in one query
2005-07-08 06:32 UTC Ramakrishnan Muralidharan <ramakrishnanm@pervasive-postgres.com>
` Re: two sums in one query
2005-07-08 07:36 UTC Kenneth Gonsalves <lawgon@thenilgiris.com>
` Re: two sums in one query
2005-07-08 13:49 UTC PFC <lists@boutiquenumerique.com>
` Re: two sums in one query
2005-07-08 14:07 UTC Bruno Wolff III <bruno@wolff.to>
` Re: two sums in one query
2005-07-08 14:49 UTC PFC <lists@boutiquenumerique.com>
` Re: two sums in one query
2005-07-08 15:55 UTC Bruno Wolff III <bruno@wolff.to>
[7+ messages in thread]
Re: getting back autonumber ... Another MsSQL Comparation Question
2005-07-08 11:56 UTC jimmy.olsen <jimmy.olsen@ig.com.br>
` Re: getting back autonumber ... Another MsSQL Comparation Question
2005-07-08 12:32 UTC Michael Fuhr <mike@fuhr.org>
[2+ messages in thread]
PostgreSQL and Delphi 6
2005-06-16 03:49 UTC Postgres Admin <postgres@productivitymedia.com>
` Re: PostgreSQL and Delphi 6
2005-06-16 12:09 UTC Postgres Admin <postgres@productivitymedia.com>
` Re: [SQL] PostgreSQL and Delphi 6
2005-06-16 12:54 UTC grupos <grupos@carvalhaes.net>
` Re: [SQL] PostgreSQL and Delphi 6
2005-06-16 13:29 UTC grupos <grupos@carvalhaes.net>
` Re: [SQL] PostgreSQL and Delphi 6
2005-06-16 15:04 UTC grupos <grupos@carvalhaes.net>
` Re: [SQL] PostgreSQL and Delphi 6
2005-06-16 17:11 UTC Din Adrian <adrian.din@easynet.ro>
` Re: PostgreSQL and Delphi 6
2005-06-16 22:31 UTC Din Adrian <adrian.din@easynet.ro>
` Re: [SQL] PostgreSQL and Delphi 6
2005-06-16 23:11 UTC Din Adrian <adrian.din@easynet.ro>
` Re: [SQL] PostgreSQL and Delphi 6
2005-06-16 23:38 UTC Din Adrian <adrian.din@easynet.ro>
` Re: PostgreSQL and Delphi 6
2005-07-08 06:22 UTC Mathew Winters <mathew@idealsoftwaresolutions.com.au>
[10+ messages in thread]
list admin note:Fwd: RE: two sums in one query
2005-07-08 05:56 UTC Kenneth Gonsalves <lawgon@thenilgiris.com>
ORDER records based on parameters in IN clause
2005-06-27 16:15 UTC Riya Verghese <riya.verghese@admissioncorp.com>
` Re: ORDER records based on parameters in IN clause
2005-06-28 04:57 UTC Michael Fuhr <mike@fuhr.org>
` Re: ORDER records based on parameters in IN clause
2005-06-29 00:13 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: ORDER records based on parameters in IN clause
2005-06-29 11:19 UTC Russell Simpkins <russellsimpkins@hotmail.com>
` Re: ORDER records based on parameters in IN clause
2005-06-29 11:44 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: ORDER records based on parameters in IN clause
2005-06-29 11:57 UTC Michael Fuhr <mike@fuhr.org>
` Re: ORDER records based on parameters in IN clause
2005-06-29 12:09 UTC Zac <zaccheob@inwind.it>
` Re: ORDER records based on parameters in IN clause
2005-06-29 12:12 UTC Zac <zaccheob@inwind.it>
` Re: ORDER records based on parameters in IN clause
2005-06-29 14:22 UTC Russell Simpkins <russellsimpkins@hotmail.com>
` Re: ORDER records based on parameters in IN clause
2005-06-29 14:33 UTC Michael Fuhr <mike@fuhr.org>
` Re: ORDER records based on parameters in IN clause
2005-06-29 15:07 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: ORDER records based on parameters in IN clause
2005-06-30 07:34 UTC M.D.G. Lange <mlange@dltmedia.nl>
` Re: ORDER records based on parameters in IN clause
2005-06-30 07:51 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: ORDER records based on parameters in IN clause
2005-06-30 10:39 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: ORDER records based on parameters in IN clause
2005-06-30 11:58 UTC Daryl Richter <daryl@brandywine.com>
` ORDER records based on parameters in IN clause
2005-07-07 21:01 UTC Riya Verghese <riya.verghese@admissioncorp.com>
[16+ messages in thread]
Left joins
1999-07-12 18:25 UTC Peter Eisentraut <peter@pathwaynet.com>
` Left Joins...
2001-05-27 22:45 UTC Michael Richards <michael@fastmail.ca>
` Re: Left Joins...
2001-05-30 13:33 UTC Renato De Giovanni <rdg@viafractal.com.br>
` left joins
2005-07-06 10:01 UTC Grant Morgan <grant@ryuuguu.com>
` Re: left joins
2005-07-06 10:30 UTC Richard Huxton <dev@archonet.com>
` Re: left joins
2005-07-06 10:33 UTC Nick Stone <nick@harelane.com>
` Re: left joins
2005-07-06 10:52 UTC Grant Morgan <grant@ryuuguu.com>
` Re: left joins
2005-07-06 14:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: left joins
2005-07-07 00:19 UTC Ragnar Hafstað <gnari@simnet.is>
` Re: left joins
2005-07-07 01:11 UTC Tony Wasson <ajwasson@gmail.com>
[10+ messages in thread]
Prepare plan in plpgsql
2005-07-06 19:32 UTC Jocelyn Turcotte <turcotte.j@gmail.com>
` Re: Prepare plan in plpgsql
2005-07-06 19:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: Help on Procedure running external function
2005-07-04 12:47 UTC Zac <zaccheob@inwind.it>
` Re: Help on Procedure running external function
2005-07-04 15:20 UTC KÖPFERL Robert <robert.koepferl@sonorys.at>
` Re: Help on Procedure running external function
2005-07-04 15:27 UTC Zac <zaccheob@inwind.it>
` Re: Help on Procedure running external function
2005-07-04 17:00 UTC Bruno Wolff III <bruno@wolff.to>
` Help on Procedure running external function
2005-07-04 21:14 UTC Din Adrian <adrian.din@easynet.ro>
` Re: Help on Procedure running external function
2005-07-04 23:10 UTC Din Adrian <adrian.din@easynet.ro>
` Re: Help on Procedure running external function
2005-07-05 11:47 UTC Zac <zaccheob@inwind.it>
` Re: Help on Procedure running external function
2005-07-05 12:39 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Help on Procedure running external function
2005-07-05 19:10 UTC Din Adrian <adrian.din@easynet.ro>
` Re: Help on Procedure running external function
2005-07-05 22:06 UTC Din Adrian <adrian.din@easynet.ro>
` Re: Help on Procedure running external function
2005-07-05 22:52 UTC Din Adrian <adrian.din@easynet.ro>
[11+ messages in thread]
Create connection with Oracle database from Postgres plpgsql function
2005-07-05 09:40 UTC Dinesh Pandey <dpandey@secf.com>
` Re: Create connection with Oracle database from Postgres plpgsql function
2005-07-05 10:02 UTC Michael Glaesemann <grzm@myrealbox.com>
` Re: Create connection with Oracle database from Postgres plpgsql
2005-07-05 14:26 UTC Bricklen Anderson <BAnderson@PresiNET.com>
[3+ messages in thread]
Recursive function
2005-07-05 05:05 UTC Gnanavel Shanmugam <s.gnanavel@inbox.com>
` Re: Recursive function
2005-07-05 05:32 UTC Gnanavel Shanmugam <s.gnanavel@inbox.com>
` Re: Recursive function
2005-07-05 06:27 UTC Nick Stone <nick@harelane.com>
[3+ messages in thread]
select values from interval
2005-07-04 12:00 UTC Josep Sanmartí <josep.sanmarti@openwired.net>
` Re: select values from interval
2005-07-04 17:03 UTC Bruno Wolff III <bruno@wolff.to>
[2+ messages in thread]
Some help please
2005-07-01 16:12 UTC Nick Stone <nick@harelane.com>
` Re: Some help please
2005-07-01 17:30 UTC Josh Berkus <josh@agliodbs.com>
` Re: Some help please
2005-07-01 17:42 UTC Nick Stone <nick@harelane.com>
[3+ messages in thread]
SQLCloseCursor() or SQLFreeStmt does not free memory allcated to read CLOB field in Oracle.
2005-07-01 09:04 UTC Vadivel Subramaniam <vadivel.subramaniam@flextronicssoftware.com>
UNIT-tests and SQL
2005-07-01 08:52 UTC KÖPFERL Robert <robert.koepferl@sonorys.at>
Updatable view
2005-06-30 13:50 UTC M.D.G. Lange <mlange@dltmedia.nl>
ENUM like data type
2005-06-21 15:20 UTC MRB <nomail@example.com>
` Re: ENUM like data type
2005-06-28 06:41 UTC Kenneth Gonsalves <lawgon@thenilgiris.com>
` Re: ENUM like data type
2005-06-28 11:22 UTC Mike Rylander <mrylander@gmail.com>
` Re: ENUM like data type
2005-06-28 12:37 UTC Bruno Wolff III <bruno@wolff.to>
` Re: ENUM like data type
2005-06-28 16:58 UTC PFC <lists@boutiquenumerique.com>
` Re: ENUM like data type
2005-06-28 18:22 UTC Martín Marqués <martin@bugs.unl.edu.ar>
` Re: ENUM like data type
2005-06-28 18:46 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: ENUM like data type
2005-06-28 19:55 UTC Nick Johnson <arachnid@notdot.net>
` Re: ENUM like data type
2005-06-29 07:09 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: ENUM like data type
2005-06-29 12:40 UTC KÖPFERL Robert <robert.koepferl@sonorys.at>
` Re: ENUM like data type
2005-06-29 13:21 UTC Martín Marqués <martin@bugs.unl.edu.ar>
` Re: ENUM like data type
2005-06-29 13:28 UTC Rod Taylor <pg@rbt.ca>
` Re: ENUM like data type
2005-06-29 21:20 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: ENUM like data type
2005-06-29 22:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ENUM like data type
2005-06-30 08:01 UTC KÖPFERL Robert <robert.koepferl@sonorys.at>
` Re: ENUM like data type
2005-06-30 11:13 UTC Peter Eisentraut <peter_e@gmx.net>
[16+ messages in thread]
Error saving image to PostgresSQL 8.x database
2005-06-29 23:13 UTC Fred Cunningham <cunningham_fred@hotmail.com>
` Re: Error saving image to PostgresSQL 8.x database
2005-06-30 03:56 UTC Josh Berkus <josh@agliodbs.com>
[2+ messages in thread]
Foreign key pg_dump issue and serial column type
2005-06-30 00:25 UTC Vsevolod (Simon) Ilyushchenko <simonf@cshl.edu>
` Re: Foreign key pg_dump issue and serial column type
2005-06-30 01:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
cross-table reference
2005-06-22 09:26 UTC Mukesh Ghatiya <mukeshg@juniper.net>
` Re: cross-table reference
2005-06-28 12:47 UTC Bruno Wolff III <bruno@wolff.to>
` Re: cross-table reference
2005-06-29 13:23 UTC Bruno Wolff III <bruno@wolff.to>
[3+ messages in thread]
Insert rule and default values for PK
2005-06-29 12:53 UTC KÖPFERL Robert <robert.koepferl@sonorys.at>
people who buy A, also buy C, D, E
2005-04-26 02:21 UTC Dan Langille <dan@langille.org>
` Re: people who buy A, also buy C, D, E
2005-04-26 04:28 UTC Ramakrishnan Muralidharan <ramakrishnanm@pervasive-postgres.com>
` Re: people who buy A, also buy C, D, E
2005-04-26 12:24 UTC Christoph Haller <ch@rodos.fzk.de>
` Re: people who buy A, also buy C, D, E
2005-04-26 12:25 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: people who buy A, also buy C, D, E
2005-04-26 12:35 UTC Dan Langille <dan@langille.org>
` Re: people who buy A, also buy C, D, E
2005-04-26 13:27 UTC Christoph Haller <ch@rodos.fzk.de>
` Re: people who buy A, also buy C, D, E
2005-06-25 03:35 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: people who buy A, also buy C, D, E
2005-06-25 14:00 UTC Jan Wieck <JanWieck@Yahoo.com>
` Re: people who buy A, also buy C, D, E
2005-06-26 16:25 UTC PFC <lists@boutiquenumerique.com>
` Re: people who buy A, also buy C, D, E
2005-06-28 23:53 UTC Greg Sabino Mullane <greg@turnstep.com>
[10+ messages in thread]
Unique primary index?
2005-06-23 12:43 UTC orange_crush_068@hotmail.com
` Re: Unique primary index?
2005-06-28 07:50 UTC M.D.G. Lange <mlange@dltmedia.nl>
` Re: Unique primary index?
2005-06-28 12:53 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Unique primary index?
2005-06-28 17:01 UTC PFC <lists@boutiquenumerique.com>
` Re: Unique primary index?
2005-06-28 17:47 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[5+ 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