pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDISTINCT ON not working...?
2007-02-19 22:25 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
` Re: DISTINCT ON not working...?
2007-02-20 04:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: DISTINCT ON not working...?
2007-02-20 04:36 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
` Re: DISTINCT ON not working...?
2007-02-20 12:33 UTC Marcin Stępnicki <mstepnicki@gmail.com>
` Re: DISTINCT ON not working...?
2007-02-20 22:12 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
[5+ messages in thread]
cartesian product
2007-02-19 16:58 UTC Salman Tahir <salmantahir1@gmail.com>
` Re: cartesian product
2007-02-19 17:56 UTC Luiz K. Matsumura <luiz@planit.com.br>
` Re: cartesian product
2007-02-19 18:07 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: cartesian product
2007-02-19 18:09 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[4+ messages in thread]
Uppercase and Lowercase
2007-02-19 15:22 UTC Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
` Re: Uppercase and Lowercase
2007-02-19 15:25 UTC Bart Degryse <Bart.Degryse@indicator.be>
` Re: Uppercase and Lowercase
2007-02-19 15:30 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Uppercase and Lowercase
2007-02-19 15:39 UTC Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
` Re: Uppercase and Lowercase
2007-02-19 15:48 UTC Bart Degryse <Bart.Degryse@indicator.be>
` Re: Uppercase and Lowercase
2007-02-19 15:54 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Uppercase and Lowercase
2007-02-19 16:05 UTC Bart Degryse <Bart.Degryse@indicator.be>
[7+ messages in thread]
How to analyse the indexes in postgres?
2007-02-18 08:15 UTC Karthikeyan Sundaram <skarthi98@hotmail.com>
` Re: How to analyse the indexes in postgres?
2007-02-18 08:21 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: How to analyse the indexes in postgres?
2007-02-18 12:59 UTC Charley Tiggs <lists@tiggs.net>
[3+ messages in thread]
Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-07 22:43 UTC Greg Wittel <gwittel@proofpoint.com>
` Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-08 11:23 UTC Michael Fuhr <mike@fuhr.org>
` Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-08 14:14 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-08 15:07 UTC Michael Fuhr <mike@fuhr.org>
` Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-08 15:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-08 15:55 UTC Michael Fuhr <mike@fuhr.org>
` Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-08 15:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
2007-02-18 01:47 UTC Bruce Momjian <bruce@momjian.us>
[8+ messages in thread]
(no subject)
2000-02-19 07:31 UTC Mohit Marwaha <mohit_marwaha@mumbai.tcs.co.in>
` sub-limiting a query
2007-02-17 12:56 UTC Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
` Re: sub-limiting a query
2007-02-17 15:00 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: sub-limiting a query
2007-02-17 17:35 UTC M.P.Dankoor <m.p.dankoor@gmail.com>
` Re: sub-limiting a query
2007-02-17 17:47 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: sub-limiting a query
2007-02-17 18:21 UTC M.P.Dankoor <m.p.dankoor@gmail.com>
` Re: sub-limiting a query
2007-02-17 18:40 UTC Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
[7+ messages in thread]
(no subject)
2000-02-19 07:26 UTC Mohit Marwaha <mohit_marwaha@mumbai.tcs.co.in>
` ordering of selected rows from an ordered subselect
2007-02-17 09:32 UTC Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
` Re: ordering of selected rows from an ordered subselect
2007-02-17 15:24 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: ordering of selected rows from an ordered subselect
2007-02-17 16:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Debug (is it PostgreSQL?)
2007-02-16 18:59 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Debug (is it PostgreSQL?)
2007-02-16 19:04 UTC Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
` Fwd: [ADMIN] Debug (is it PostgreSQL?)
2007-02-16 19:11 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Fwd: [ADMIN] Debug (is it PostgreSQL?)
2007-02-17 00:33 UTC Hiroshi Saito <z-saito@guitar.ocn.ne.jp>
[4+ messages in thread]
There is a different cast than ::MyOtherType() ?
2007-02-16 12:30 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: There is a different cast than ::MyOtherType() ?
2007-02-16 14:34 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: There is a different cast than ::MyOtherType() ?
2007-02-16 14:34 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
[3+ messages in thread]
Retrieving 'Credit' when 'C'
2007-02-15 16:17 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Retrieving 'Credit' when 'C'
2007-02-15 16:28 UTC Rodrigo De León <rdeleonp@gmail.com>
` Re: Retrieving 'Credit' when 'C'
2007-02-15 16:30 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Retrieving 'Credit' when 'C'
2007-02-15 16:44 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Retrieving 'Credit' when 'C'
2007-02-15 21:47 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
` Re: Retrieving 'Credit' when 'C'
2007-02-16 12:09 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
[6+ messages in thread]
"for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql?
2007-02-15 11:19 UTC Walter Cruz <walter.php@gmail.com>
` Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql?
2007-02-15 13:35 UTC Richard Huxton <dev@archonet.com>
` Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql?
2007-02-15 14:04 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql?
2007-02-15 17:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql?
2007-02-15 22:59 UTC Walter Cruz <walter.php@gmail.com>
[5+ messages in thread]
problem with join
2007-02-14 22:21 UTC Edward W. Rouse <erouse@comsquared.com>
` Re: problem with join
2007-02-15 04:02 UTC Bruno Wolff III <bruno@wolff.to>
[2+ messages in thread]
Regaring posting a query
2007-02-14 06:44 UTC sahaanaa subha <sahaanaa@kify.net>
` Re: Regaring posting a query
2007-02-14 22:34 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
[2+ messages in thread]
COPY FROM query.
2007-02-11 23:19 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: COPY FROM query.
2007-02-11 23:27 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: COPY FROM query.
2007-02-11 23:55 UTC Joe <dev@freedomcircle.net>
` Re: COPY FROM query.
2007-02-12 00:09 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: COPY FROM query.
2007-02-12 00:47 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
` Re: COPY FROM query.
2007-02-12 00:51 UTC Paul Lambert <paul.lambert@autoledgers.com.au>
` Re: COPY FROM query.
2007-02-12 08:21 UTC Richard Huxton <dev@archonet.com>
` Re: COPY FROM query
2007-02-12 20:24 UTC Steve Midgley <public@misuse.org>
[8+ messages in thread]
Deadlock on transaction
2007-02-12 17:43 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Deadlock on transaction
2007-02-12 17:48 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Deadlock on transaction
2007-02-12 18:08 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: [SQL] Deadlock on transaction
2007-02-12 18:43 UTC Richard Huxton <dev@archonet.com>
` Re: [ADMIN] Deadlock on transaction
2007-02-12 18:45 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: [SQL] Deadlock on transaction
2007-02-12 18:47 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: [SQL] Deadlock on transaction
2007-02-12 18:57 UTC Richard Huxton <dev@archonet.com>
` Re: [ADMIN] Deadlock on transaction
2007-02-12 18:59 UTC Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
` Re: [SQL] Deadlock on transaction
2007-02-12 19:20 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Deadlock on transaction
2007-02-12 19:20 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: [ADMIN] Deadlock on transaction
2007-02-12 19:27 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: [SQL] Deadlock on transaction
2007-02-12 19:50 UTC Richard Huxton <dev@archonet.com>
` Re: [SQL] Deadlock on transaction
2007-02-12 19:56 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[13+ messages in thread]
RE : Sum sets of records
2007-02-12 15:59 UTC Sylvain Barrette <sylvain@remax-quebec.com>
Sum sets of records
2007-02-12 15:41 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Sum sets of records
2007-02-12 15:46 UTC Bart Degryse <Bart.Degryse@indicator.be>
[2+ messages in thread]
Password Policy
2007-02-10 19:55 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Password Policy
2007-02-10 21:32 UTC Clodoaldo <clodoaldo.pinto.neto@gmail.com>
` Re: Password Policy
2007-02-10 21:46 UTC Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
` Re: Password Policy
2007-02-10 22:46 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
` Re: Password Policy
2007-02-11 05:18 UTC Christopher Browne <cbbrowne@acm.org>
` Re: [SQL] Password Policy
2007-02-12 08:19 UTC Richard Huxton <dev@archonet.com>
[6+ messages in thread]
huge disparities in =/IN/BETWEEN performance
2007-02-08 23:57 UTC George Pavlov <gpavlov@mynewplace.com>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 01:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 02:03 UTC George Pavlov <gpavlov@mynewplace.com>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 02:14 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 03:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 04:12 UTC Joe <dev@freedomcircle.net>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 04:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 05:01 UTC Joe <dev@freedomcircle.net>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 14:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 19:21 UTC George Pavlov <gpavlov@mynewplace.com>
` Re: huge disparities in =/IN/BETWEEN performance
2007-02-09 22:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
[11+ messages in thread]
Have anyone this man e-mail ?
2007-02-09 18:50 UTC Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
alias not applied
2007-02-09 16:04 UTC Sabin Coanda <sabin.coanda@deuromedia.ro>
` Re: alias not applied
2007-02-09 16:19 UTC Frank Bax <fbax@sympatico.ca>
` Re: alias not applied
2007-02-09 16:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: alias not applied
2007-02-09 16:35 UTC Sabin Coanda <sabin.coanda@deuromedia.ro>
[4+ messages in thread]
Seeking quick way to clone a row, but give it a new pk.
2007-02-07 22:21 UTC Bryce Nesbitt <bryce1@obviously.com>
` Re: Seeking quick way to clone a row, but give it a new pk.
2007-02-08 00:17 UTC Philip Hallstrom <postgresql@philip.pjkh.com>
` Re: Seeking quick way to clone a row, but give it a new pk.
2007-02-08 07:16 UTC Bryce Nesbitt <bryce1@obviously.com>
` Re: Seeking quick way to clone a row, but give it a new pk.
2007-02-08 07:19 UTC Bryce Nesbitt <bryce1@obviously.com>
` Re: Seeking quick way to clone a row, but give it a new pk.
2007-02-08 07:58 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: Seeking quick way to clone a row, but give it a new pk.
2007-02-08 09:32 UTC Aarni Ruuhimäki <aarni@kymi.com>
` Re: Seeking quick way to clone a row, but give it a new pk.
2007-02-08 16:18 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: Seeking quick way to clone a row, but give it a new pk.
2007-02-09 00:09 UTC John DeSoi <desoi@pgedit.com>
[8+ messages in thread]
metaphone and nysiis in postgres
2007-02-07 19:46 UTC Demel, Jeff <Jeff.Demel@JavelinDirect.com>
` Re: metaphone and nysiis in postgres
2007-02-07 20:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: metaphone and nysiis in postgres
2007-02-07 20:13 UTC Demel, Jeff <Jeff.Demel@JavelinDirect.com>
` Re: metaphone and nysiis in postgres
2007-02-07 20:31 UTC Demel, Jeff <Jeff.Demel@JavelinDirect.com>
` Re: metaphone and nysiis in postgres
2007-02-08 09:05 UTC Richard Huxton <dev@archonet.com>
` Re: metaphone and nysiis in postgres
2007-02-08 16:59 UTC Demel, Jeff <Jeff.Demel@JavelinDirect.com>
` Re: metaphone and nysiis in postgres
2007-02-08 20:48 UTC Jan Muszynski <postgres@jancm.org>
[7+ messages in thread]
COPY FROM - force a value
2007-02-08 19:13 UTC Demel, Jeff <Jeff.Demel@JavelinDirect.com>
` Re: COPY FROM - force a value
2007-02-08 19:21 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: COPY FROM - force a value
2007-02-08 19:55 UTC Demel, Jeff <Jeff.Demel@JavelinDirect.com>
[3+ messages in thread]
Differentiate Between Zero-Length String and NULL Column Values
2007-01-30 05:32 UTC Phillip Smith <phillip.smith@weatherbeeta.com.au>
` Re: Differentiate Between Zero-Length String and NULL Column Values
2007-01-30 05:45 UTC Michael Fuhr <mike@fuhr.org>
` Re: Differentiate Between Zero-Length String and NULL Column Values
2007-01-30 13:13 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 13:38 UTC Bart Degryse <Bart.Degryse@indicator.be>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 14:23 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 14:37 UTC Herouth Maoz <herouth@tippcom.co.il>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 16:38 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 16:55 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 18:14 UTC Geoff Tolley <geoff@polimetrix.com>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 18:59 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 19:34 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-30 20:17 UTC Jamie A Lawrence <jal@clueinc.net>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-01-31 20:18 UTC BillR <iambill@williamrosmus.com>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-02-01 18:53 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Differentiate Between Zero-Length String and NULLColumn Values
2007-02-08 19:30 UTC Jan Wieck <JanWieck@Yahoo.com>
[15+ 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