pgsql-sql 2002-06 Thread Index (1/3)

Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

pgsql-sql 2002-06 Thread Index (1/3)

Last updated: Wed Jan 18 04:35:49 2012
417 messages

Main Index
[Prev Page]
[Next Page]

[no subject] Unknown (Wed 18 04:35)
[no subject] Unknown (Wed 18 04:35)
[no subject] Unknown (Wed 18 04:35)
pl/pgsql capabilities? Ferenc Engard (Sun 30 23:43)
selecting from integer[] Kelly (Sat 29 11:42)

Re: selecting from integer[] Christopher Kings-Lynne (Sat 29 14:32)
Re: selecting from integer[] Stephan Szabo (Sat 29 21:11)

pg_group members Kelly (Fri 28 22:25)

Re: pg_group members Bruce Momjian (Fri 28 23:27)

something similar to "on delete cascade" ? Albrecht Berger (Fri 28 20:14)

Re: something similar to "on delete cascade" ? Josh Berkus (Fri 28 21:41)

Two-way query Vernon Wu (Fri 28 17:41)
pg_user and pg_group q u a d r a (Fri 28 17:39)
creating functional index over multiple columns Chantal Ackermann (Fri 28 11:09)

Re: creating functional index over multiple columns Christopher Kings-Lynne (Sat 29 04:23)
<Possible follow-ups>
Re: creating functional index over multiple columns Chantal Ackermann (Fri 28 11:17)

transaction in plpgsql Joseph Syjuco (Fri 28 04:13)

Re: transaction in plpgsql Josh Berkus (Fri 28 06:09)
Re: transaction in plpgsql Nils Höglund (Fri 28 06:54)
<Possible follow-ups>
Re: transaction in plpgsql Josh Berkus (Fri 28 16:08)

time difference q u a d r a (Fri 28 03:53)
Function question David Hassell (Thu 27 20:42)

<Possible follow-ups>
Re: Function question Steve Brett (Fri 28 14:15)
Re: Function question Jie Liang (Fri 28 16:05)

Unsubscription -- How? David Secret (Thu 27 19:58)
to_char() and order-by Jeff Boes (Thu 27 19:57)

Re: to_char() and order-by Karel Zak (Fri 28 07:59)

Re: to_char() and order-by Jeff Boes (Fri 28 12:50)

Re: Slow SELECT -> Growing Database Marcos Garcia (Thu 27 17:23)

Re: Slow SELECT -> Growing Database Stephan Szabo (Thu 27 18:13)
Re: Slow SELECT -> Growing Database Marc Spitzer (Thu 27 19:37)
Re: Slow SELECT -> Growing Database Tatsuo Ishii (Fri 28 01:46)

Subtraction of Dates Valerie Goodman (Thu 27 14:22)

<Possible follow-ups>
Re: Subtraction of Dates Steve Brett (Fri 28 14:21)

graphical interface - admin q u a d r a (Thu 27 11:43)

Re: graphical interface - admin Ron Peterson (Thu 27 19:18)
Re: graphical interface - admin David BOURIAUD (Fri 28 06:32)

Re: graphical interface - admin Josh Berkus (Fri 28 16:06)
Re: graphical interface - admin Robert Treat (Fri 28 16:14)

<Possible follow-ups>
Re: graphical interface - admin terry (Fri 28 17:58)

Re: graphical interface - admin Josh Berkus (Fri 28 19:27)

CHECK clause doesn't work with CASE clause J�rg Holetschek (Thu 27 09:53)

Re: CHECK clause doesn't work with CASE clause Tom Lane (Thu 27 14:31)
Re: CHECK clause doesn't work with CASE clause Richard Poole (Thu 27 16:05)
Re: CHECK clause doesn't work with CASE clause Richard Huxton (Thu 27 16:15)

pg_restore cannot restore function Jie Liang (Thu 27 00:48)

<Possible follow-ups>
pg_restore cannot restore function Jie Liang (Fri 28 18:57)

Re: pg_restore cannot restore function Jan Wieck (Fri 28 20:12)

Re: pg_restore cannot restore function Jie Liang (Fri 28 20:51)
Re: pg_restore cannot restore function Jie Liang (Fri 28 20:51)

Calculating with sql Dennis Kaarsemaker (Wed 26 21:25)

Re: Calculating with sql Masaru Sugawara (Thu 27 18:03)

Re: Calculating with sql Dennis Kaarsemaker (Thu 27 19:38)
Re: Calculating with sql Masaru Sugawara (Fri 28 14:43)

Possibility of Index-Only access in PostgreSQL? Gunther Schadow (Wed 26 18:49)

Re: Possibility of Index-Only access in PostgreSQL? Tom Lane (Wed 26 23:40)

Re: Possibility of Index-Only access in PostgreSQL? Gunther Schadow (Thu 27 16:10)

Re: Possibility of Index-Only access in PostgreSQL? Christopher Kings-Lynne (Thu 27 03:58)

Efficient Query For Mapping IP Addresses To Country Code. Rajesh Kumar Mallah. (Wed 26 15:30)
sequence chages after firing update Subhashini Karthikeyan (Wed 26 11:47)

Re: sequence chages after firing update Stephan Szabo (Wed 26 15:28)
Re: sequence chages after firing update Rajesh Kumar Mallah. (Wed 26 15:52)

Quickest way to insert unique records? Ian Cass (Wed 26 10:18)
what is the difference between default 0 vs default '0' Beth Gatewood (Wed 26 00:55)

Re: what is the difference between default 0 vs default '0' Lee Harr (Wed 26 02:39)
Re: what is the difference between default 0 vs default '0' Christopher Kings-Lynne (Wed 26 06:51)

PostgreSQL Cookbook update Roberto Mello (Tue 25 22:48)
Performance Ideas Eric (Tue 25 20:38)

Re: Performance Ideas Tom Lane (Wed 26 15:21)

2 Selects 1 is faster, why? Eric (Tue 25 20:22)

Re: 2 Selects 1 is faster, why? Alvar Freude (Wed 26 16:33)

Re: 2 Selects 1 is faster, why? Masaru Sugawara (Thu 27 16:04)

Re: 2 Selects 1 is faster, why? Keith Gray (Thu 27 23:43)

Re: 2 Selects 1 is faster, why? Tom Lane (Fri 28 03:57)

unique index on function and column Bruno Wolff III (Tue 25 18:10)

Re: unique index on function and column Tom Lane (Tue 25 19:20)

Re: unique index on function and column Bruno Wolff III (Tue 25 19:21)

Re: unique index on function and column Josh Berkus (Tue 25 20:55)

Re: unique index on function and column Bruno Wolff III (Tue 25 21:16)

altering column width tdn (Tue 25 06:47)
Slow SELECT with distinct, in a TIMESTAMP type column Marcos Garcia (Mon 24 16:12)

Re: Slow SELECT with distinct, in a TIMESTAMP type column Stephan Szabo (Mon 24 21:29)

Re: Slow SELECT with distinct, in a TIMESTAMP type column Marcos Garcia (Mon 24 21:59)

Re: Slow SELECT with distinct, in a TIMESTAMP type column Stephan Szabo (Mon 24 21:56)

assign count() result to a declared variable in plpgsql Joseph Syjuco (Mon 24 12:24)

Re: assign count() result to a declared variable in plpgsql Tom Lane (Mon 24 18:10)
Re: assign count() result to a declared variable in plpgsql Jeff Eckermann (Mon 24 19:27)

variance aggregate function incorrect? Reference Materials reg create aggregate Joseph Syjuco (Mon 24 12:24)

Re: variance aggregate function incorrect? Reference Materials reg create aggregate Tom Lane (Mon 24 17:13)
Re: variance aggregate function incorrect? Reference Materials Bruce Momjian (Mon 24 18:34)

Select + min question Devrim GUNDUZ (Sun 23 11:36)

Re: Select + min question Christopher Kings-Lynne (Sun 23 12:19)

Re: Select + min question Devrim GUNDUZ (Mon 24 12:23)

Re: Select + min question Mathieu Arnold (Sun 23 12:23)

A problem on running a sql script in DBVisualizer Vernon Wu (Sat 22 17:15)
Obtaining primary key information from pg system tables Kris (Sat 22 10:36)

Re: Obtaining primary key information from pg system tables Dmitri Colebatch (Sat 22 10:43)

Re: Obtaining primary key information from pg system tables Kris (Sat 22 11:13)

Can somebody help me to optimize this huge query? Dirk Lutzebaeck (Fri 21 21:35)

Re: Can somebody help me to optimize this huge query? Josh Berkus (Mon 24 23:04)

index problem Oleg Lebedev (Fri 21 20:55)
FW: RESTORE A TABLE Jie Liang (Fri 21 20:48)
Presenting consistent data Ian Lynagh (Fri 21 19:56)
Re: [ADMIN] Incredible.. Cliff Wells (Fri 21 16:05)

Re: [ADMIN] Incredible.. Larry Rosenman (Fri 21 16:12)

Optimizer question with equivalent joins Dirk Lutzebaeck (Fri 21 14:31)

Re: Optimizer question with equivalent joins Tom Lane (Fri 21 15:33)

date_ge and time_ge juerg . rietmann (Fri 21 09:35)

Re: date_ge and time_ge Achilleus Mantzios (Fri 21 09:42)

Re: skip weekends Rudi Starcevic (Fri 21 06:06)

Re: skip weekends Cliff Wells (Fri 21 07:44)
Re: skip weekends Josh Berkus (Fri 21 21:17)

SQL Challenge: Skip Weekends Josh Berkus (Fri 21 01:09)

Re: SQL Challenge: Skip Weekends Joe Conway (Fri 21 05:33)

Re: SQL Challenge: Skip Weekends Josh Berkus (Fri 21 21:17)

Re: SQL Challenge: Skip Weekends Jean-Luc Lachance (Fri 21 18:32)

Re: SQL Challenge: Skip Weekends Josh Berkus (Fri 21 20:52)

how to sort a birthday list ? Michael Agbaglo (Thu 20 19:11)

Re: how to sort a birthday list ? David Stanaway (Thu 20 22:26)

Re: how to sort a birthday list ? Michael Agbaglo (Fri 21 09:23)

Re: how to sort a birthday list ? Josh Berkus (Fri 21 01:06)

Re: how to sort a birthday list ? Michael Agbaglo (Fri 21 08:38)

Re: how to sort a birthday list ? Bruno Wolff III (Fri 21 12:36)

Re: how to sort a birthday list ? Jan Wieck (Fri 21 13:22)

rowtype and ecpg Alla (Thu 20 17:22)

Re: rowtype and ecpg Christoph Haller (Mon 24 12:24)

Re: rowtype and ecpg Alla (Mon 24 20:49)

slow DELETE queries Denis (Thu 20 13:32)

Re: slow DELETE queries Manfred Koizar (Thu 20 15:07)

Re: slow DELETE queries Denis (Mon 24 12:42)

psql -E <dbname> Floating exception (coredump) Christoph Haller (Thu 20 08:39)

Re: psql -E <dbname> Floating exception (coredump) Tom Lane (Thu 20 13:32)

Rows affected Rudi Starcevic (Thu 20 04:00)

Re: Rows affected Gaetano Mendola (Thu 20 07:26)

Assign values to array afa (Wed 19 20:50)

Message not available
- Re: Assign values to array Arve Fahlvik (Thu 20 15:06)

Which one is faster? Wei Weng (Wed 19 20:07)

Re: Which one is faster? Bruce Momjian (Wed 19 20:38)

Re: Which one is faster? Jan Wieck (Thu 20 12:23)

Re: Which one is faster? Bruce Momjian (Thu 20 16:12)

syntax for access an alias in the where clause ? Michael Agbaglo (Wed 19 18:55)

Re: syntax for access an alias in the where clause ? Wei Weng (Wed 19 20:22)

Re: syntax for access an alias in the where clause ? Michael Agbaglo (Wed 19 21:21)

Re: syntax for access an alias in the where clause ? Ross J. Reedstrom (Thu 20 00:00)

Re: syntax for access an alias in the where clause ? Tom Lane (Wed 19 22:04)
Re: syntax for access an alias in the where clause ? Jeff Eckermann (Wed 19 22:08)
Re: syntax for access an alias in the where clause ? Stephan Szabo (Wed 19 22:19)

Tagging rows into collections? Steve Wampler (Wed 19 17:07)

Re: Tagging rows into collections? Tom Lane (Wed 19 21:21)

Re: Tagging rows into collections? Steve Wampler (Thu 20 13:54)
Re: Tagging rows into collections? Richard Huxton (Thu 20 18:38)

SQL performance issue with PostgreSQL compared to MySQL Jeff Self (Wed 19 13:30)

Re: SQL performance issue with PostgreSQL compared to MySQL Tom Lane (Wed 19 14:57)

Re: SQL performance issue with PostgreSQL compared to MySQL Bruce Momjian (Wed 19 17:26)

Re: SQL performance issue with PostgreSQL compared to Josh Berkus (Wed 19 15:08)

Re: SQL performance issue with PostgreSQL compared to Achilleus Mantzios (Thu 20 07:17)

Re: SQL performance issue with PostgreSQL compared to Josh Berkus (Fri 21 01:04)

Mirar y reenviar por favor!!! son 2 segundos Marta Beatriz Caldentey (Wed 19 11:27)
Joining three data sources. Janning Vygen (Wed 19 10:14)

Re: Joining three data sources. Masaru Sugawara (Wed 19 14:12)

Re: Joining three data sources. Janning Vygen (Wed 19 19:00)
Re: Joining three data sources. Janning Vygen (Thu 20 06:07)

Re: Joining three data sources. Masaru Sugawara (Thu 20 13:59)

Aggregates not allowed in WHERE clause? Joachim Trinkwitz (Wed 19 08:05)

Re: Aggregates not allowed in WHERE clause? Christopher Kings-Lynne (Wed 19 08:13)
Re: Aggregates not allowed in WHERE clause? Achilleus Mantzios (Wed 19 08:16)
Re: Aggregates not allowed in WHERE clause? Christoph Haller (Wed 19 08:21)

Re: Aggregates not allowed in WHERE clause? Joachim Trinkwitz (Thu 20 08:06)

Help with a "recursive" query Jerome Alet (Wed 19 07:30)

Re: Help with a "recursive" query Oleg Bartunov (Wed 19 08:45)

is it easy to change the create sequence algorithm? Kevin Brannen (Wed 19 00:45)

Re: is it easy to change the create sequence algorithm? Josh Berkus (Fri 21 21:39)
Re: is it easy to change the create sequence algorithm? Andrew Hammond (Fri 21 22:30)

date_part Rudi Starcevic (Tue 18 23:31)

Re: date_part Josh Berkus (Wed 19 01:09)

text vs varchar Wei Weng (Tue 18 22:33)

Re: text vs varchar Josh Berkus (Tue 18 23:22)

Re: text vs varchar Wei Weng (Wed 19 00:43)
Re: text vs varchar Josh Goldberg (Wed 19 01:33)
Re: text vs varchar Achilleus Mantzios (Wed 19 07:44)

Main Index
[Prev Page]
[Next Page]

Mail converted by MHonArc

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group