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

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

March 19, 2005

Thread Author Time
Group by 15 Minute Steps Martin Knipper 21:55

March 20, 2005

Thread Author Time
Re: Mail Authentification tgl 16:21

March 21, 2005

Thread Author Time
Re: Group by 15 Minute Steps Jonathan Daugherty 04:30
Re: tablename as function parameter Jonathan Daugherty 05:08
equivalent of oracle rank() in postgres Chandan_Kumaraiah 07:08
Re: Trigger with parameters Richard Huxton 08:02
Re: date subtraction Richard Huxton 08:07
index scan Mihail Nasedkin 08:26
Re: index scan Richard Huxton 09:15
Re: Christoph Haller 09:54
Re: index scan Mihail Nasedkin 10:05
Re: Your question about date Béatrice Yueksel 10:59
Re: index scan Richard Huxton 11:35
Accessing other Databases osmar 14:11
CASE not working Martín Marqués 14:18
Re: CASE not working Alvaro Herrera 14:29
Re: query Thomas F.O'Connell 14:33
Re: CASE not working Martín Marqués 14:40
Re: query Bruno Wolff III 15:17
"Flattening" query result into columns Thomas Borg Salling 21:57
Re: "Flattening" query result into columns Leif B. Kristensen 22:37
C function extending postgres Theo Galanakis 22:46
Re: "Flattening" query result into columns Sean Davis 23:27

March 22, 2005

Thread Author Time
Re: C function extending postgres Jonathan Daugherty 00:21
Re: "Flattening" query result into columns PFC 00:35
Re: "Flattening" query result into columns Scott Marlowe 00:46
Re: equivalent of oracle rank() in postgres Greg Sabino Mullane 02:52
Re: C function extending postgres Theo Galanakis 05:09
Re: C function extending postgres Jonathan Daugherty 05:32
Re: C function extending postgres Theo Galanakis 05:43
Re: timestamp precision - can I control precision at select time Christoph Haller 08:50
Re: Your question about date Christoph Haller 09:38
Re: Your question about date Béatrice Yueksel 09:57
Auto Numbering sreekanth pk 19:25
Self-referencing table question Sean Davis 19:33
Permissions on tables subhash 19:55
Re: Self-referencing table question Sean Davis 20:40
Re: Self-referencing table question Richard Huxton 20:59
Permissions on tables and views subhash 21:28
Re: Permissions on tables and views Michael Fuhr 21:46

March 23, 2005

Thread Author Time
Re: Self-referencing table question Sean Davis 00:07
view function on pg_toast bandeng 03:39
Re: view function on pg_toast Michael Fuhr 04:51
Re: view function on pg_toast Mihail Nasedkin 05:01
Re: view function on pg_toast Mihail Nasedkin 05:09
Re: "Flattening" query result into columns Tambet Matiisen 08:13
Re: Self-referencing table question Sean Davis 11:04
Re: best way to swap two records (computer details) Gary Stainburn 17:26
Re: best way to swap two records (computer details) Gary Stainburn 17:28
How do I do this? Wei Weng 17:37
Re: best way to swap two records (computer details) Michael Long 17:59
Re: [despammed] How do I do this? Andreas Kretschmer 18:52
Re: view function on pg_toast bandeng 20:53
Re: best way to swap two records (computer details) Gary Stainburn 23:25

March 24, 2005

Thread Author Time
Re: How do I do this? Greg Sabino Mullane 01:34
Re: timestamp precision - can I control precision at select time [email protected] 03:47
Is there a way to find a schema name Kalyani Chennupati 16:03
Re: Self-referencing table question Edmund Bacon 16:13
Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael 16:41
Re: Funtions + plpgsql + contrib/pgcrypto = ?? Jim Buttafuoco 17:14
Re: Self-referencing table question Sean Davis 17:30
Re: Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael 17:43
Re: Funtions + plpgsql + contrib/pgcrypto = ?? Jim Buttafuoco 17:58
Re: Self-referencing table question Edmund Bacon 18:11
Re: Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael 18:59
Re: Self-referencing table question Sean Davis 19:01
Re: Self-referencing table question Edmund Bacon 19:37
Re: Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael 20:22
Re: Self-referencing table question Sean Davis 20:30

March 25, 2005

Thread Author Time
Calling functions from Delete View (+ contrib/pgcrypto) = madness ?? Moran.Michael 01:30
Re: Calling functions from Delete View (+ contrib/pgcrypto) = madness ?? Jim Buttafuoco 03:44
Foreign key ASAKALAL 15:31
Re: Calling functions from Delete View (+ contrib/pgcrypto) Moran.Michael 15:53
Re: Calling functions from Delete View (+ contrib/pgcrypto) Michael Fuhr 16:15
Securing VIEWS that use contrib/pgcrypto -- how? Moran.Michael 16:46
Re: Securing VIEWS that use contrib/pgcrypto -- how? Tom Lane 16:54
Merging item codes using referential integrity Andrus Moor 19:46
select a list of schema names Andrus Moor 19:50

March 26, 2005

Thread Author Time
How to make update statement to work Andrus Moor 15:13

March 27, 2005

Thread Author Time
Re: Auto Numbering Michael Fuhr 07:26
Re: Foreign key Michael Fuhr 07:47
Re: How to make update statement to work Tom Lane 07:57
Re: select a list of schema names Michael Fuhr 08:04
Re: Accessing other Databases Michael Fuhr 08:09
Re: Is there a way to find a schema name Michael Fuhr 08:22
Postgre: 8.0.1 Create Table insde a function gives strange error at execution time Franz Stuetzle 12:17
detaching triggers Enrico Weigelt 15:41
(non)zero function Enrico Weigelt 15:58
Re: Postgre: 8.0.1 Create Table insde a function gives strange error at execution time Tom Lane 16:01
Re: detaching triggers Mike Rylander 16:20
Re: Foreign key Bruno Wolff III 16:33
Re: (non)zero function Bruno Wolff III 16:51
Re: "Flattening" query result into columns Thomas Borg Salling 21:09

March 28, 2005

Thread Author Time
Executing Anonymous Blocks imad 07:27
connectby queries Chandan_Kumaraiah 08:32
Re: (non)zero function Christian Kratzer 08:42
Re: Executing Anonymous Blocks Alvaro Herrera 14:43
Re: connectby queries Michael Fuhr 16:37
Postgres 7.3 migrate to 8.0 date problems. Thomas Seeber 19:44
Re: Postgres 7.3 migrate to 8.0 date problems. Scott Marlowe 20:48
cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz 21:43
Re: cost of CREATE VIEW ... AS SELECT DISTINCT Scott Marlowe 22:04

March 29, 2005

Thread Author Time
Re: Executing Anonymous Blocks Neil Conway 07:59
Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz 10:07
Re: Merging item codes using referential integrity Richard Huxton 10:12
Re: cost of CREATE VIEW ... AS SELECT DISTINCT Sean Davis 10:59
when using a bound cursor, error found... 윤동수 11:49
Re: Executing Anonymous Blocks Andrew Dunstan 11:55
Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz 13:21
Re: cost of CREATE VIEW ... AS SELECT DISTINCT Bruno Wolff III 13:29
Re: cost of CREATE VIEW ... AS SELECT DISTINCT Alvaro Herrera 13:58
Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz 14:12
Re: cost of CREATE VIEW ... AS SELECT DISTINCT Bruno Wolff III 15:04
Re: cost of CREATE VIEW ... AS SELECT DISTINCT Bruno Wolff III 15:07
Re: cost of CREATE VIEW ... AS SELECT DISTINCT Tom Lane 15:54
Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz 16:01
a very big table _moray 16:25

March 30, 2005

Thread Author Time
Date/Time Conversion James G Wilkinson 00:04
Re: when using a bound cursor, error found... Michael Fuhr 07:29
can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE frank 09:07
Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE PFC 09:48
Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE frank 10:33
New record position lucas 13:50
Re: New record position Oleg Bartunov 14:12
Re: New record position PFC 14:19
Re: New record position lucas 16:17
Re: RE : Foreign key Michael Fuhr 16:31
Re: RE : Foreign key Bruno Wolff III 17:26
Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Bruno Wolff III 17:52
Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Michael Fuhr 17:52
Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Bruno Wolff III 19:02
delphi access question? Joel Fradkin 20:15
Re: [ODBC] delphi access question? Raymond O'Donnell 20:53
save me from an unconstrained join Robert Treat 20:54
Re: [SQL] delphi access question? Gregory S. Williamson 21:19
Re: Postgres 7.3 migrate to 8.0 date problems. Robert Treat 21:23
Re: [SQL] delphi access question? Joel Fradkin 21:36
Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Greg Stark 22:51
Re: New record position Chris Browne 23:04

March 31, 2005

Thread Author Time
A SQL Question About distinct, limit, group by, having, aggregate =?BIG5?Q?=AAL=A9?=[=?BIG5?Q?=BEN?= 02:29
Re: A SQL Question About distinct, limit, group by, having, aggregate Jaime Casanova 03:01
Re: Postgres 7.3 migrate to 8.0 date problems. Michael Fuhr 03:11
Re: delphi access question Lin Kun Hsin 04:22
Re: A SQL Question About distinct, limit, group by, having, aggregate Lin Kun Hsin 05:14
Re: save me from an unconstrained join Richard Huxton 07:15
Re: A SQL Question About distinct, limit, group by, having, Ragnar Hafstað 08:05
Help - Oracle 9i to PostgreSQL SQL conversion Dinesh Pandey 11:05
Re: A SQL Question About distinct, limit, group by, having, aggregate Lin Kun Hsin 12:24
Re: Speed up slow select - was gone blind Dinesh Pandey 12:44
Re: New record position Greg Patnude 16:42
Re: New record position Chris Browne 17:33
unsubscribe pgsql-sql Robin M. 18:31
Re: unsubscribe pgsql-sql Chris Hebrard 23:45

April 1, 2005

Thread Author Time
asynchrous triggers Enrico Weigelt 03:52
Re: asynchrous triggers Alvaro Herrera 04:07
gone blind - can't see syntax error Gary Stainburn 11:36
Re: gone blind - can't see syntax error Dinesh Pandey 11:51
Re: gone blind - can't see syntax error Mike Rylander 11:55
Re: gone blind - can't see syntax error Kenneth Gonsalves 12:01
Re: gone blind - can't see syntax error Gary Stainburn 12:08
Speed up slow select - was gone blind Gary Stainburn 12:32
Re: Speed up slow select - was gone blind Mike Rylander 12:46
Re: Speed up slow select - was gone blind Richard Huxton 13:00
Order of items in FROM causes error? Rosser Schwarz 16:24
Re: Order of items in FROM causes error? Tom Lane 16:35
Re: Order of items in FROM causes error? Stephan Szabo 16:37
Query history file Mauro Bertoli 23:42

April 3, 2005

Thread Author Time
Re: Query history file Bruce Momjian 02:56
Re: Date/Time Conversion Yasir Malik 03:49
Re: Date/Time Conversion Tom Lane 03:50
Re: Query history file PFC 08:03
Re: [SQL] delphi access question? Andreas Pflug 09:20
How to store directory like structures? Axel Straschil 10:13
Re: Merging item codes using referential integrity Andrus Moor 10:50
Re: a very big table Sean Davis 12:38
Re: Date/Time Conversion Yasir Malik 13:45
Re: How to store directory like structures? Oleg Bartunov 17:00
Re: How to store directory like structures? Axel Straschil 17:26
Re: How to store directory like structures? PFC 18:09
Re: How to store directory like structures? PFC 18:11
Re: How to store directory like structures? Oleg Bartunov 18:18
Re: a very big table PFC 18:21
Re: How to store directory like structures? Axel Straschil 18:34
Re: How to store directory like structures? Axel Straschil 19:03
Re: How to store directory like structures? Oleg Bartunov 19:24
Re: How to store directory like structures? PFC 19:57
Re: Date/Time Conversion Greg Stark 20:35
Re: How to store directory like structures? Axel Straschil 20:36
Re: How to store directory like structures? Axel Straschil 20:39

April 4, 2005

Thread Author Time
Re: a very big table Tom Lane 00:50
select & group by Michael L. Hostbaek 10:16
Re: [SQL] delphi access question? Miguel Juan 10:29
Re: select & group by Richard Huxton 10:39
Re: select & group by Ragnar Hafstað 10:47
Re: select & group by Ragnar Hafstað 10:59
Re: select & group by Michael L. Hostbaek 12:23
Chield Serial lucas 13:01
Migrated Oracle database to PostgreSQL ?? Dinesh Pandey 13:41
Re: Migrated Oracle database to PostgreSQL ?? Yasir Malik 19:35
Re: Migrated Oracle database to PostgreSQL ?? Dinesh Pandey 19:57

Browse Archives

Prev | Next