pgsql-sql since 2006-08-18 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

Aug. 18, 2006

Thread Author Time
Re: Help with optional parameters Rob Tester 01:57
Re: Multiple DB join Sumeet 15:07
Re: Multiple DB join Andrew Sullivan 15:20
trigger needs to check in multiple tables. Jacobo García 17:17

Aug. 19, 2006

Thread Author Time
Re: trigger needs to check in multiple tables. Michael Fuhr 01:01
Re: NULL becomes default Markus Schaber 07:51

Aug. 20, 2006

Thread Author Time
Re: NULL becomes default Julian Scarfe 10:34

Aug. 21, 2006

Thread Author Time
Re: NULL becomes default Andrew Sullivan 10:27
Triggers Ezequias Rodrigues da Rocha 12:03
Re: Triggers Kaloyan Iliev 12:19

Aug. 22, 2006

Thread Author Time
Re: Triggers Kis János Tamás 06:34
to get DD-MM-YYYY format of data Penchalaiah P. 13:16
Re: to get DD-MM-YYYY format of data Alvaro Herrera 13:27
Re: to get DD-MM-YYYY format of data Michael Fuhr 13:27
joining VIEWs Brian Cox 16:40
Re: joining VIEWs Stephan Szabo 16:59

Aug. 23, 2006

Thread Author Time
SQL92 compliance Daniel CAUNE 01:40
error with mor than 1 sub-select chrisj 01:47
Re: SQL92 compliance Michael Glaesemann 01:54
Re: error with mor than 1 sub-select Osvaldo Kussama 02:03
Re: error with mor than 1 sub-select Michael Fuhr 02:06
Re: error with mor than 1 sub-select chrisj 02:26
Re: error with mor than 1 sub-select Erik Jones 14:57
Re: SQL92 compliance Peter Eisentraut 16:11
Re: SQL92 compliance Tom Lane 17:40
The length of the sql query Emi Lu 17:53
Re: SQL92 compliance Scott Marlowe 18:28
All columns from table in a joined query MHahn 19:14
Deleting Functions Scott Petersen 19:29
Re: All columns from table in a joined query Sumeet 19:44
Re: Deleting Functions Jim Buttafuoco 19:56
Re: All columns from table in a joined query Tom Lane 21:26
Re: Deleting Functions Tom Lane 21:34

Aug. 24, 2006

Thread Author Time
Re: SQL92 compliance Peter Eisentraut 06:42
Re: SQL92 compliance Peter Eisentraut 06:43
Re: The length of the sql query Emi Lu 12:58
Re: The length of the sql query Tom Lane 14:34
Importing data from csv Sumeet 14:47
double precision vs. numeric Aarni Ruuhimäki 16:36
Re: double precision vs. numeric Peter Eisentraut 16:51
Function to retrieve the Id column Ezequias Rodrigues da Rocha 17:07
Re: double precision vs. numeric Michael Fuhr 17:24
Re: double precision vs. numeric Tom Lane 17:29
Re: Function to retrieve the Id column Michael Fuhr 18:13
Re: Deleting Functions Scott Petersen 18:35
Performance Problem with sub-select using array Travis Whitton 19:01
Lock Problem André José Guergolet 20:27
Re: Lock Problem Andrew Sullivan 20:52
RES: Lock Problem André José Guergolet 21:12
Re: RES: Lock Problem Scott Marlowe 21:19
Re: Importing data from csv Phillip Smith 23:16
Re: Importing data from csv Scot P. Floess 23:57
Re: Importing data from csv Scot P. Floess 23:59

Aug. 25, 2006

Thread Author Time
Re: Importing data from csv Phillip Smith 00:04
Re: Importing data from csv Scot P. Floess 00:19
Re: RES: Lock Problem Christopher Browne 03:00
Re: RES: Lock Problem Tom Lane 04:29
Re: double precision vs. numeric Aarni Ruuhimäki 05:12
Re: Importing data from csv Michael Fuhr 06:06
Re: RES: Lock Problem Andrew Sullivan 10:52
Best way to do this query.. Henry Ortega 20:16
Re: Best way to do this query.. Andrew Sullivan 20:21
Re: Best way to do this query.. Richard Broersma Jr 20:40
Re: Best way to do this query.. Henry Ortega 20:43
Re: Best way to do this query.. Richard Broersma Jr 22:59

Aug. 27, 2006

Thread Author Time
Create Assertion -- Question from a newbie Richard Broersma Jr 07:19
Re: Create Assertion -- Question from a newbie Bruno Wolff III 13:54
Re: Create Assertion -- Question from a newbie Richard Broersma Jr 14:39

Aug. 28, 2006

Thread Author Time
Re: Performance Problem with sub-select using array Aaron Bono 04:10
Re: Importing data from csv Aaron Bono 04:14
hi ........i have a query related to MS reporting services Dinesh Tiwari 07:47
Re: double precision vs. numeric Aarni Ruuhimäki 08:08
Re: hi ........i have a query related to MS reporting services Magnus Hagander 08:09
Re: Create Assertion -- Question from a newbie Andrew Sullivan 10:46
Re: double precision vs. numeric Michael Fuhr 13:08
Re: double precision vs. numeric Aarni Ruuhimäki 13:32
Re: double precision vs. numeric Michael Fuhr 13:45
Re: double precision vs. numeric D'Arcy J.M. Cain 13:49
Trigger on Insert to Update only newly inserted fields? Henry Ortega 14:02
Re: Create Assertion -- Question from a newbie Alvaro Herrera 14:27
Temporary Views or tables Sumeet 14:29
Re: Trigger on Insert to Update only newly inserted fields? Michael Fuhr 14:57
Re: Trigger on Insert to Update only newly inserted fields? Henry Ortega 15:53
Fastest way to get max tstamp Henry Ortega 18:10
Re: Fastest way to get max tstamp Richard Broersma Jr 19:23

Aug. 29, 2006

Thread Author Time
dinamic sql Manso Gomez, Ramon 10:31
Re: Trigger on Insert to Update only newly inserted fields? Michael Fuhr 10:38
Re: dinamic sql Jaime Casanova 12:33
Re: Performance Problem with sub-select using array Aaron Bono 14:28
Re: Performance Problem with sub-select using array Aaron Bono 14:34
[No subject] Sumeet 16:44
Re: Andrew Sullivan 17:40
Re: to get DD-MM-YYYY format of data codeWarrior 18:15

Aug. 30, 2006

Thread Author Time
UTF8 Vs Latin9 and valid encoding. Marcelo . 04:48
Re: UTF8 Vs Latin9 and valid encoding. Markus Schaber 08:26
Trigger with Stored Procedure [Client Points] Ezequias Rodrigues da Rocha 11:56
Error on function parameters Ezequias Rodrigues da Rocha 12:50
Re: Error on function parameters Tom Lane 12:58
Re: Error on function parameters Anton de Wet 13:06
Re: UTF8 Vs Latin9 and valid encoding. Marcelo . 13:52
Re: Create Assertion -- Question from a newbie Gregory Stark 20:47
Re: Create Assertion -- Question from a newbie Andrew Sullivan 22:00

Aug. 31, 2006

Thread Author Time
Re: Create Assertion -- Question from a newbie Christopher Browne 03:08
ERROR: SELECT query has no destination for result data Ezequias Rodrigues da Rocha 13:00
Re: ERROR: SELECT query has no destination for result data 2000 Informatica 13:51
Re: ERROR: SELECT query has no destination for result data John DeSoi 13:57
Checking types Ezequias Rodrigues da Rocha 13:58
Re: ERROR: SELECT query has no destination for result data Joe 14:21
Re: ERROR: SELECT query has no destination for result data John DeSoi 14:26
Re: Trigger on Insert to Update only newly inserted fields? Aaron Bono 14:55
Re: Trigger with Stored Procedure [Client Points] Aaron Bono 15:29
How to get the row that start a trigger Ezequias Rodrigues da Rocha 18:43
Re: Trigger with Stored Procedure [Client Points] Aaron Bono 21:42

Sept. 1, 2006

Thread Author Time
help with pagila Walter Cruz 13:31
Re: help with pagila Andrew Sullivan 15:21
Re: help with pagila Walter Cruz 17:26
Re: help with pagila Andrew Sullivan 17:40
Re: help with pagila Tomas Vondra 18:06
Re: help with pagila Scott Marlowe 19:58
Re: help with pagila Tom Lane 20:21
Re: help with pagila Tomas Vondra 20:25
Re: help with pagila Walter Cruz 20:46
Re: help with pagila Stephan Szabo 21:12

Sept. 2, 2006

Thread Author Time
Mac Address Ezequias Rodrigues da Rocha 20:42
Re: Mac Address Milen A. Radev 22:34
Re: Mac Address Bruno Wolff III 23:24

Sept. 3, 2006

Thread Author Time
Re: Mac Address Andreas Kretschmer 07:07
Re: How to get the row that start a trigger Aaron Bono 23:17

Sept. 4, 2006

Thread Author Time
Re: help with pagila Markus Schaber 07:55

Sept. 5, 2006

Thread Author Time
pg_dump M. Santosa 07:22
Postgres regexp matching failure? Mario Splivalo 10:18
Re: pg_dump Andrew Sullivan 10:54
Re: Postgres regexp matching failure? Aaron Bono 13:42
Re: Postgres regexp matching failure? Tom Lane 14:11
Re: Postgres regexp matching failure? Mario Splivalo 14:16
Re: Postgres regexp matching failure? Mario Splivalo 14:17
Re: Postgres regexp matching failure? Alvaro Herrera 14:21
Re: pg_dump Tom Lane 14:28
Re: Postgres regexp matching failure? Mario Splivalo 15:03
Re: Postgres regexp matching failure? Alvaro Herrera 15:17
Re: Postgres regexp matching failure? Tom Lane 15:22
Re: Subquery alternatives? codeWarrior 16:07
Re: Postgres regexp matching failure? Aaron Bono 16:10

Sept. 6, 2006

Thread Author Time
Way to reverse ordering of an IP ... ? Marc G. Fournier 03:51
Query regarding to MS reporting services (Grand total problem) Dinesh Tiwari 05:30
Re: Way to reverse ordering of an IP ... ? Philippe Lang 06:35
Re: Query regarding to MS reporting services (Grand total problem) Andrew Sullivan 11:31
Substitute a Character Judith 16:53
Re: Substitute a Character Andreas Kretschmer 17:09
Re: Substitute a Character Chris Mair 17:14
Re: Substitute a Character Daryl Richter 20:20
Evaluation of if conditions Daniel CAUNE 22:32
Re: Evaluation of if conditions Gregory S. Williamson 23:02
Re: Evaluation of if conditions Oisin Glynn 23:04
Re: Evaluation of if conditions Joe 23:40

Sept. 7, 2006

Thread Author Time
Re: Evaluation of if conditions Tom Lane 04:10
Problem with FOR UPDATE Kaloyan Iliev 09:00
Re: Substitute a Character Kaloyan Iliev 09:03
Re: Postgres regexp matching failure? Mario Splivalo 10:32
Is it possible to left join based on previous joins result Emi Lu 13:13
Re: Query regarding to MS reporting services (Grand total problem) Aaron Bono 14:01
Re: Is it possible to left join based on previous joins result Emi Lu 14:02
Re: Problem with FOR UPDATE Tom Lane 14:15
Re: Problem with FOR UPDATE Stephan Szabo 14:20
Re: Is it possible to left join based on previous joins result Stephan Szabo 14:26
Re: Is it possible to left join based on previous joins Ragnar 14:30
Thanks Kaloyan Iliev 15:29

Sept. 9, 2006

Thread Author Time
Re: Is it possible to left join based on previous joins result Aaron Bono 17:26

Sept. 11, 2006

Thread Author Time
on connect/on disconnect Robert Edwards 00:57
where clause subqueries vs multiple rows results James Cloos 03:27
Re: on connect/on disconnect Aaron Bono 04:28
Re: on connect/on disconnect Robert Edwards 04:52
Re: where clause subqueries vs multiple rows results Aaron Bono 04:54
Re: where clause subqueries vs multiple rows results Aaron Bono 04:55
Re: where clause subqueries vs multiple rows results Richard Broersma Jr 05:01
Re: on connect/on disconnect Aaron Bono 05:10
hi i am gettin error when i am deleting a function from my pgadmin Penchalaiah P. 07:46
Re: on connect/on disconnect Markus Schaber 10:31
Re: on connect/on disconnect Markus Schaber 10:36
Re: where clause subqueries vs multiple rows results James Cloos 12:04
Re: on connect/on disconnect Jorge Godoy 12:09
Re: hi i am gettin error when i am deleting a function from my pgadmin Aaron Bono 14:46
Fwd: hi i am gettin error when i am deleting a function from my pgadmin Aaron Bono 14:47
case insensitive regex clause with some latin1 characters fails Ragnar Österlund 19:09
Re: case insensitive regex clause with some latin1 characters fails Tom Lane 19:41
Re: case insensitive regex clause with some latin1 characters Emi Lu 20:14
text+number, find largest entry gabor 23:34

Sept. 12, 2006

Thread Author Time
Re: text+number, find largest entry Tom Lane 00:15
Re: on connect/on disconnect Robert Edwards 00:43
Re: hi i am gettin error when i am deleting a function from Robert Edwards 00:46
Two optimization questions Mezei Zoltán 10:23
Sorting items in aggregate function Steven Murdoch 15:46
Joint a table back on itself? paallen 15:55
Re: Joint a table back on itself? Daryl Richter 18:09
Re: Sorting items in aggregate function Michael Fuhr 18:17
Re: on connect/on disconnect Aaron Bono 18:21
Re: Sorting items in aggregate function Volkan YAZICI 18:24
Re: Two optimization questions Aaron Bono 18:46
Re: Two optimization questions Mezei Zoltán 19:06
How to get all users under a group Emi Lu 19:24

Browse Archives

Prev | Next