pgsql-sql since 2005-10-19 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Oct. 19, 2005

Thread Author Time
Re: query to file Michael Fuhr 00:05
Re: query to file Michael Glaesemann 00:09
Re: Scott Marlowe 00:30
writable joined view Sarah Asmaels 01:10
Re: problems with array Matthew Peter 03:09
Re: problems with array Michael Fuhr 03:35
how to create rule as on delete efa din 04:43
Re: query to file Eugene E. 05:41
Re: Problem -Postgre sql Michael Glaesemann 05:41
Re: problems with array Matthew Peter 05:54
Re: Problem -Postgre sql Chris Travers 06:03
Re: Double query (limit and offset) Richard Huxton 07:25
Re: Double query (limit and offset) Janning Vygen 07:34
Re: Query information needed Oliver Elphick 07:44
Re: Problem while using start transaction ans commit; Oliver Elphick 07:45
Field Separator not working? Mario Splivalo 10:19
Re: SEVEN cross joins?!?!? Frank Bax 10:42
Re: Field Separator not working? Richard Huxton 10:43
Re: Field Separator not working? Mario Splivalo 12:19
Sql - Error en ejecución de función Postgres desde cliente VFoxPro Adriana Marcela Aguirre 15:59
Character set error Mauricio Fernandez A. 16:24
Re: Problem -Postgre sql Muralidharan Ramakrishnan 18:33
NULL in IN clause Havasvölgyi Ottó 20:17
Re: NULL in IN clause Terry Fielder 20:41
Re: NULL in IN clause David Dick 20:43
Re: NULL in IN clause Stephan Szabo 21:00
Re: [pgsql-advocacy] Oracle buys Innobase Guy Rouillier 21:07
Re: NULL in IN clause Tom Lane 21:11

Oct. 20, 2005

Thread Author Time
casting character varying to integer - order by numeric sort Bryce W Nesbitt 01:01
Re: casting character varying to integer - order by numeric Terry Fielder 01:34
Re: casting character varying to integer - order by numeric sort Tom Lane 03:33
automatic update or insert tobbe 06:36
Re: casting character varying to integer - order by numeric 📎 Bryce Nesbitt (mailing list account) 06:57
Re: casting character varying to integer - order by numeric Richard Huxton 07:32
Sql - Error : Relation tmp_datos already exists Adriana Marcela Aguirre 14:44
Problema con migracion de SQL a PostgreSQL Fernando Garcia 15:25
Article on Oracle & MySQL in E-week Wendell Anderson 15:38
Re: casting character varying to integer - order by numeric Bryce Nesbitt (mailing list account) 15:58
Re: pg, mysql comparison with "group by" clause Chris Travers 18:31
Re: [pgsql-advocacy] Oracle buys Innobase Doug Quale 20:29
SQL Functions gurkan 22:02

Oct. 21, 2005

Thread Author Time
Re: [pgsql-advocacy] Oracle buys Innobase Marc G. Fournier 00:45
Postgres 7.4.9 slow! Mario Splivalo 11:13
Re: Postgres 7.4.9 slow! Havasvölgyi Ottó 12:01
Re: Postgres 7.4.9 slow! Mario Splivalo 12:34
Re: Sql - Error : Relation tmp_datos already exists tobbe 12:44
Re: Postgres 7.4.9 slow! Thomas Pundt 12:52
Delete rule chain stops unexpectedly Wiebe Cazemier 14:13
Re: [pgsql-advocacy] Oracle buys Innobase Alex Turner 14:16
SQL Functions gurkan 14:19
Re: Postgres 7.4.9 slow! Tom Lane 14:20
Re: Postgres 7.4.9 slow! Mario Splivalo 14:32
Re: Delete rule chain stops unexpectedly Tom Lane 14:42
Re: Delete rule chain stops unexpectedly Wiebe Cazemier 15:01
SQL language krishnaa sridharan 15:24
Aggregate versus lineitem report Jerry Blumenthal 15:32
Re: Delete rule chain stops unexpectedly Tom Lane 16:06
Re: [pgsql-advocacy] Oracle buys Innobase Tom Lane 16:47
Reading bytea field Jochen Kokemüller 18:46
How much more would you earn? Charles 20:17
Re: Delete rule chain stops unexpectedly Wiebe Cazemier 21:51
Re: Delete rule chain stops unexpectedly Tom Lane 22:14
Blank-padding (was: Oracle buys Innobase) Dean Gibson (DB Administrator) 23:28
Re: Reading bytea field 📎 Volkan YAZICI 23:30

Oct. 22, 2005

Thread Author Time
Re: Blank-padding (was: Oracle buys Innobase) Tom Lane 03:23
Re: Blank-padding Chris Travers 05:39
Re: Blank-padding Dean Gibson (DB Administrator) 15:16
Merging lines with NULLs (with example data) MaXX 16:25

Oct. 24, 2005

Thread Author Time
unsuscribe Nicolas Cornu 09:59
[No subject] Илья Конюхов 14:18
Re: Blank-padding Scott Marlowe 14:32
Re: Blank-padding Shaun Watts 15:04
[No subject] Илья Конюхов 15:08
Re: Blank-padding Tom Lane 15:14
Re: Silke Trissl 15:20
Re: Problema con migracion de SQL a PostgreSQL Cristian Prieto 16:31
Re: query tables based on a query Bruno Wolff III 17:02

Oct. 25, 2005

Thread Author Time
Re: automatic update or insert Stewart Ben (RBAU/EQS4) * 02:43
Re: how to create rule as on delete Stewart Ben (RBAU/EQS4) * 02:45
Re: SQL language Michael Glaesemann 02:49
Re: Article on Oracle & MySQL in E-week Michael Glaesemann 02:55
Re: how to create rule as on delete elein 03:08
convert timezone to string ... Marc G. Fournier 05:42
Re: automatic update or insert PFC 08:07
Re: convert timezone to string ... Magnus Hagander 11:03
Re: writable joined view Wiebe Cazemier 12:07
Re: convert timezone to string ... Tom Lane 13:19
Re: Merging lines with NULLs (with example data) Harald Fuchs 13:42
Re: Merging lines with NULLs (with example data) Daryl Richter 14:03
Re: automatic update or insert Daryl Richter 14:38
Re: writable joined view 📎 Richard Huxton 14:49
Re: convert timezone to string ... Marc G. Fournier 15:02
Re: automatic update or insert codeWarrior 15:26
Re: Delete rule chain stops unexpectedly Wiebe Cazemier 15:30
8.0.x windows installer fails? george young 16:16
Re: 8.0.x windows installer fails? Magnus Hagander 16:27
Re: Delete rule chain stops unexpectedly Tom Lane 18:06
backend error Judith Altamirano Figueroa 23:28
broken join optimization? (8.0) chester c young 23:56

Oct. 26, 2005

Thread Author Time
?Equiv to oracle (ENABLE|DISABLE) (CONSTRAINT|TRIGGER) statements? Bath, David 01:13
Re: ?Equiv to oracle (ENABLE|DISABLE) (CONSTRAINT|TRIGGER) statements? Bruce Momjian 01:38
Re: broken join optimization? (8.0) Michael Fuhr 02:42
Re: backend error Michael Fuhr 02:51
Re: broken join optimization? (8.0) Tom Lane 03:53
padding an integer ... Marc G. Fournier 03:57
pl/* overhead ... Marc G. Fournier 03:58
Re: padding an integer ... Michael Fuhr 04:11
why vacuum Kenneth Gonsalves 04:45
Re: why vacuum Tom Lane 05:14
Re: why vacuum Michael Fuhr 05:57
Re: why vacuum Bath, David 06:22
Re: pl/* overhead ... Michael Fuhr 06:55
Re: why vacuum Tom Lane 07:00
Re: why vacuum Kenneth Gonsalves 07:49
Re: automatic update or insert Patrick JACQUOT 07:53
Re: broken join optimization? (8.0) Richard Huxton 08:31
converting epoch to timestamp Rajesh Kumar Mallah 09:05
Re: converting epoch to timestamp Richard Huxton 09:22
Re: converting epoch to timestamp A. Kretschmer 09:25
Re: converting epoch to timestamp Stef 09:31
Re: pl/* overhead ... Marc G. Fournier 09:48
SETOF RECORD RETURN VALUE Christian Paul B. Cosinas 10:34
Re: SETOF RECORD RETURN VALUE Sean Davis 10:58
RETURNS SETOF primitive returns results in parentheses Mario Splivalo 12:38
Re: RETURNS SETOF primitive returns results in parentheses Sean Davis 12:54
Re: RETURNS SETOF primitive returns results in parentheses Mario Splivalo 13:09
Re: pl/* overhead ... Jan Wieck 14:28
Re: RETURNS SETOF primitive returns results in parentheses Tom Lane 14:40
Re: why vacuum Scott Marlowe 14:44
Re: RETURNS SETOF primitive returns results in parentheses Stephan Szabo 14:46
Combining two SELECTs by same filters Volkan YAZICI 15:16
Re: why vacuum Scott Marlowe 15:19
select best price Gary Stainburn 15:21
Re: select best price Gary Stainburn 15:38
Re: Combining two SELECTs by same filters Scott Marlowe 15:59
Re: why vacuum Jan Wieck 16:09
Re: why vacuum Scott Marlowe 16:10
Re: why vacuum Tom Lane 16:12
Re: broken join optimization? (8.0) chester c young 16:12
Re: Combining two SELECTs by same filters Michael Fuhr 16:15
Re: why vacuum Scott Marlowe 16:18
Re: broken join optimization? (8.0) Tom Lane 16:39
SUM not matching up on a JOIN Tyler Kellen 17:48
Re: broken join optimization? (8.0) chester c young 18:06
Re: Combining two SELECTs by same filters Bruno Wolff III 18:29
Re: select best price Bruno Wolff III 18:40
Re: RETURNS SETOF primitive returns results in parentheses Mario Splivalo 19:41
Re: RETURNS SETOF primitive returns results in parentheses Tom Lane 19:45
Re: RETURNS SETOF primitive returns results in parentheses Mario Splivalo 19:57
Re: SUM not matching up on a JOIN Tom Lane 20:51
Re: SQL Functions Thomas F. O'Connell 22:42

Oct. 27, 2005

Thread Author Time
Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum Bath, David 00:42
Re: Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum Tom Lane 00:55
Re: why vacuum Igor Shevchenko 01:34
handling money type padmanabha konkodi 06:05
How to speed up the database query? Abdul Wahab Dahalan 07:03
Complex Query - Data from 3 tables simultaneously Amit_Wadhwa 07:37
Re: How to speed up the database query? Amit_Wadhwa 07:38
Re: How to speed up the database query? Andreas Kretschmer 07:44
Re: why vacuum Mario Splivalo 08:22
Re: why vacuum Mario Splivalo 08:22
Re: handling money type Richard Huxton 09:14
Re: Complex Query - Data from 3 tables simultaneously Richard Huxton 09:17
Re: why vacuum Andrew Sullivan 10:21
Re: Complex Query - Data from 3 tables simultaneously Amit_Wadhwa 11:23
Re: why vacuum Mario Splivalo 12:34
Re: why vacuum Richard Huxton 13:21
Re: why vacuum Jan Wieck 13:47
Re: why vacuum Jan Wieck 14:12
unsuscribe Ing. Jhon Carrillo-Venezuela 14:29
Re: handling money type codeWarrior 15:34
Re: How to speed up the database query? Christian Paul B. Cosinas 15:45
Re: why vacuum Andrew Sullivan 15:51
Re: How to speed up the database query? Bruno Wolff III 16:31
Re: why vacuum Jan Wieck 17:25
Re: How to speed up the database query? Jim C. Nasby 17:46
Re: why vacuum Jim C. Nasby 17:52
combining records from a single table and presenting them as one record Abhishek 18:00
Re: Merging lines with NULLs (with example data) MaXX 20:07
Referencing lucas 20:24
Re: combining records from a single table and presenting them as one record boinger 21:46
Re: combining records from a single table and presenting Frank Bax 23:37

Oct. 28, 2005

Thread Author Time
Re: converting epoch to timestamp Rajesh Kumar Mallah 04:28
Re: why vacuum Mario Splivalo 11:09
serial in output alessandra de gregorio 11:18
Re: why vacuum Andrew Sullivan 13:34
Fwd: Re: Referencing lucas 13:59
Re: Fwd: Re: Referencing Daryl Richter 15:40
Re: combining records from a single table and presenting them as one record Abhishek 15:47
Re: Fwd: Re: Referencing lucas 16:07
Re: Complex Query - Data from 3 tables simultaneously Muralidharan Ramakrishnan 17:10
Re: combining records from a single table and presenting them as one record Michael Fuhr 17:12
Changing location of ORDER BY has large effect on performance, but not results... Jason Turner 21:30
information_schema problem Kyle Bateman 23:06

Oct. 29, 2005

Thread Author Time
Re: Complex Query - Data from 3 tables simultaneously Amit_Wadhwa 05:45
Two tables or three? James Cloos 13:38
Re: Aggregate versus lineitem report Bruno Wolff III 17:20
Re: Two tables or three? Tom Lane 17:46
Re: Two tables or three? James Cloos 23:59

Oct. 31, 2005

Thread Author Time
Nested Table in PostgreSQL or some alternative Variants Thomas Zuberbuehler 13:22

Browse Archives

Prev | Next