pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedReturning the total number of rows as a separate column when using limit
2007-10-31 15:55 UTC Andreas Joseph Krogh <andreak@officenet.no>
` Returning the total number of rows as a separate column when using limit
2007-11-05 07:36 UTC Andreas Joseph Krogh <andreak@officenet.no>
` Re: Returning the total number of rows as a separate column when using limit
2007-11-05 14:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Returning the total number of rows as a separate column when using limit
2007-11-05 14:38 UTC Andreas Joseph Krogh <andreak@officenet.no>
` Re: Returning the total number of rows as a separate column when using limit
2007-11-05 15:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Returning the total number of rows as a separate column when using limit
2007-11-05 15:27 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Returning the total number of rows as a separate column when using limit
2007-11-05 16:33 UTC Andreas Joseph Krogh <andreak@officenet.no>
` Re: Returning the total number of rows as a separate column when using limit
2007-11-05 18:54 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Returning the total number of rows as a separate column when using limit
2007-11-06 06:58 UTC Gregory Stark <stark@enterprisedb.com>
[9+ messages in thread]
omitting redundant join predicate
2007-11-04 13:14 UTC Ehab Galal <ehabgalal123@hotmail.com>
` Re: omitting redundant join predicate
2007-11-04 16:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: omitting redundant join predicate
2007-11-05 15:15 UTC Ehab Galal <ehabgalal123@hotmail.com>
` Re: omitting redundant join predicate
2007-11-05 16:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
changing encoding of a postgres database
2007-11-05 11:55 UTC Kenneth Gonsalves <lawgon@thenilgiris.com>
Backup Database
2007-10-31 17:14 UTC Joanne Salerno <joanne.salerno@noaa.gov>
` Re: Backup Database
2007-10-31 19:04 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Backup Database
2007-11-05 09:30 UTC Asko Oja <ascoja@gmail.com>
[3+ messages in thread]
SELECT DISTINCT ... ORDER BY UPPER(column_name) fails
2007-11-04 16:49 UTC Aymeric Levaux <aymeric@javablackbelt.com>
` Re: SELECT DISTINCT ... ORDER BY UPPER(column_name) fails
2007-11-04 17:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Scrolling cursors in PL/PgSQL
2007-11-01 20:19 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: Scrolling cursors in PL/PgSQL
2007-11-01 21:02 UTC Raymond O'Donnell <rod@iol.ie>
` Re: Scrolling cursors in PL/PgSQL
2007-11-01 21:05 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Scrolling cursors in PL/PgSQL
2007-11-01 21:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
puzzled by SELECT INTO
2007-10-30 20:43 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: puzzled by SELECT INTO
2007-10-30 20:57 UTC Rodrigo De León <rdeleonp@gmail.com>
` Re: puzzled by SELECT INTO
2007-10-31 12:28 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
[3+ messages in thread]
Perfomance benefit using Min() against order by & limit 1?
2007-10-30 20:42 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: Perfomance benefit using Min() against order by & limit 1?
2007-10-30 21:00 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
[2+ messages in thread]
update from select
2003-10-29 14:37 UTC Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: update from select
2003-10-29 14:58 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: update from select
2003-10-29 15:36 UTC Gary Stainburn <gary.stainburn@ringways.co.uk>
` update from select
2007-10-29 09:18 UTC dev@kbsolutions.ch
` Re: update from select
2007-10-29 10:45 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: update from select
2007-10-29 11:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: update from select
2007-10-29 14:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: update from select
2007-10-29 15:28 UTC dev@kbsolutions.ch
` Re: update from select
2007-10-29 15:46 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: update from select
2007-10-29 18:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
[10+ messages in thread]
Select into with dynamic criteria in a plpgsql function
2007-10-28 23:11 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: Select into with dynamic criteria in a plpgsql function
2007-10-28 23:19 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
[2+ messages in thread]
Removing whitespace using regexp_replace
2007-10-28 11:20 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Removing whitespace using regexp_replace
2007-10-28 11:42 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Removing whitespace using regexp_replace
2007-10-28 12:15 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Removing whitespace using regexp_replace
2007-10-28 12:32 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Removing whitespace using regexp_replace
2007-10-28 14:35 UTC Thomas Kellerer <spam_eater@gmx.net>
[5+ messages in thread]
request for help with COPY syntax
2007-10-23 16:19 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-23 16:44 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: request for help with COPY syntax
2007-10-23 16:46 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: request for help with COPY syntax
2007-10-24 02:51 UTC Adrian Klaver <aklaver@comcast.net>
` Re: request for help with COPY syntax
2007-10-24 06:59 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-24 07:02 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-24 07:10 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: request for help with COPY syntax
2007-10-24 09:19 UTC Harald Fuchs <hf0217x@protecting.net>
` Re: request for help with COPY syntax
2007-10-24 13:56 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: request for help with COPY syntax
2007-10-25 15:35 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-25 16:16 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-25 16:57 UTC Bricklen Anderson <banderson@presinet.com>
` Re: request for help with COPY syntax
2007-10-25 19:13 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-25 21:16 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: request for help with COPY syntax
2007-10-26 02:16 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-26 03:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: request for help with COPY syntax
2007-10-26 04:26 UTC Chuck D. <pgsql-list@nullmx.com>
` Re: request for help with COPY syntax
2007-10-26 16:29 UTC Chuck D. <pgsql-list@nullmx.com>
[18+ messages in thread]
JOINing based on whether an IP address is contained within a CIDR range?
2007-10-25 18:22 UTC Jamie Tufnell <diesql@googlemail.com>
` Re: JOINing based on whether an IP address is contained within a CIDR range?
2007-10-25 19:21 UTC Erik Jones <erik@myemma.com>
` Re: JOINing based on whether an IP address is contained within a CIDR range?
2007-10-25 19:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: JOINing based on whether an IP address is contained within a CIDR range?
2007-10-26 11:44 UTC Harald Fuchs <hf0217x@protecting.net>
` Re: JOINing based on whether an IP address is contained within a CIDR range?
2007-10-26 12:03 UTC Jonah H. Harris <jonah.harris@gmail.com>
[5+ messages in thread]
get only rows for latest version of contents
2007-10-24 09:29 UTC Sébastien Meudec <seb@jack.fr>
` Re: get only rows for latest version of contents
2007-10-24 09:55 UTC Christian Kindler <christian.kindler@gmx.net>
` Re: get only rows for latest version of contents
2007-10-25 06:50 UTC Sébastien Meudec <seb@jack.fr>
` Re: get only rows for latest version of contents
2007-10-25 14:34 UTC Erik Jones <erik@myemma.com>
` Re: get only rows for latest version of contents
2007-10-26 07:59 UTC Sébastien Meudec <seb@jack.fr>
[5+ messages in thread]
hidden versioning system
2007-10-25 19:32 UTC Darnell Brawner <darnell@smackdabstudios.com>
(repost) Help understanding expressions in order by clause
2007-10-25 16:44 UTC Steve Midgley <public@misuse.org>
` Re: (repost) Help understanding expressions in order by clause
2007-10-25 17:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
ERROR: failed to re-find parent key in "pk_ep07"
2007-10-25 02:31 UTC Otniel Michael <otmic_ie@yahoo.com>
` Re: ERROR: failed to re-find parent key in "pk_ep07"
2007-10-25 04:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ERROR: failed to re-find parent key in "pk_ep07"
2007-10-25 08:26 UTC Otniel Michael <otmic_ie@yahoo.com>
` Re: ERROR: failed to re-find parent key in "pk_ep07"
2007-10-25 08:42 UTC Gregory Stark <stark@enterprisedb.com>
` Re: ERROR: failed to re-find parent key in "pk_ep07"
2007-10-25 08:50 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
[5+ messages in thread]
Quick question re foreign keys.
2007-10-24 02:03 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: Quick question re foreign keys.
2007-10-24 02:14 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
` Re: Quick question re foreign keys.
2007-10-24 02:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Quick question re foreign keys.
2007-10-24 03:00 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: Quick question re foreign keys.
2007-10-24 03:09 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: Quick question re foreign keys.
2007-10-24 05:27 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Quick question re foreign keys.
2007-10-24 07:43 UTC Nis Jørgensen <nis@superlativ.dk>
` Re: Quick question re foreign keys.
2007-10-24 14:27 UTC Robins Tharakan <tharakan@gmail.com>
` Re: Quick question re foreign keys.
2007-10-24 14:53 UTC D'Arcy J.M. Cain <darcy@druid.net>
[9+ messages in thread]
two queryes in a single tablescan
2007-10-17 12:30 UTC Stefano Dal Pra <s.dalpra@gmail.com>
` Re: two queryes in a single tablescan
2007-10-17 13:00 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: two queryes in a single tablescan
2007-10-17 13:15 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: two queryes in a single tablescan
2007-10-17 13:21 UTC Stefano Dal Pra <s.dalpra@gmail.com>
` Re: two queryes in a single tablescan
2007-10-17 13:39 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: two queryes in a single tablescan
2007-10-18 02:24 UTC 李彦 Ian Li <liyan82@gmail.com>
` Re: [SQL] two queryes in a single tablescan
2007-10-20 10:58 UTC Markus Schaber <schabi@logix-tt.com>
` Re: [SQL] two queryes in a single tablescan
2007-10-20 17:19 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: [SQL] two queryes in a single tablescan
2007-10-20 22:02 UTC Erik Jones <erik@myemma.com>
[9+ messages in thread]
backup database tablespace with rsync?
2007-10-20 02:11 UTC chester c young <chestercyoung@yahoo.com>
` Re: backup database tablespace with rsync?
2007-10-20 09:01 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
Refactored queries needing validation of syntactic equivalence
2007-10-10 23:25 UTC Mike Adams <madams55075@comcast.net>
` Re: Refactored queries needing validation of syntactic equivalence
2007-10-11 07:24 UTC Richard Huxton <dev@archonet.com>
` Re: Refactored queries needing validation of syntactic equivalence
2007-10-13 17:44 UTC Mike Adams <madams55075@comcast.net>
` Re: Refactored queries needing validation of syntactic equivalence
2007-10-16 08:27 UTC Richard Huxton <dev@archonet.com>
` Re: Refactored queries needing validation of syntactic equivalence
2007-10-20 05:45 UTC Mike Adams <madams55075@comcast.net>
[5+ messages in thread]
(no subject)
2007-10-17 18:49 UTC Boergesson, Cheryl <Cheryl.Boergesson@gdit.com>
when inserting to table, text type parameter become NULL (after big assignment to this parameter)
2007-10-17 07:09 UTC Sofer, Yuval <Yuval_Sofer@bmc.com>
what's wrong with my date comparison?
2007-10-16 17:57 UTC Tena Sakai <tsakai@gallo.ucsf.edu>
` Re: what's wrong with my date comparison?
2007-10-16 18:00 UTC Tena Sakai <tsakai@gallo.ucsf.edu>
` Re: what's wrong with my date comparison?
2007-10-16 18:04 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: what's wrong with my date comparison?
2007-10-16 18:09 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: what's wrong with my date comparison?
2007-10-16 20:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Having difficulty writing a "best-fit" query..
2007-10-16 16:46 UTC Jamie Tufnell <diesql@googlemail.com>
` Re: Having difficulty writing a "best-fit" query..
2007-10-16 17:11 UTC Rodrigo De León <rdeleonp@gmail.com>
` Re: Having difficulty writing a "best-fit" query..
2007-10-16 17:14 UTC Richard Broersma Jr <rabroersma@yahoo.com>
` Re: Having difficulty writing a "best-fit" query..
2007-10-16 17:32 UTC Harald Fuchs <hf0217x@protecting.net>
` Re: Having difficulty writing a "best-fit" query..
2007-10-16 17:34 UTC Michael Glaesemann <grzm@seespotcode.net>
[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