pgsql-sql since 2005-04-09 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30

April 9, 2005

Thread Author Time
Getting the output of a function used in a where clause Bill Lawrence 01:43
Re: getting count for a specific querry John DeSoi 15:00
Re: getting count for a specific querry Bob Henkel 15:43
Re: getting count for a specific querry John DeSoi 15:51
subselect query time and loops problem pankaj naug 20:21
Re: subselect query time and loops problem Tom Lane 23:26
Re: Question on triggers and plpgsql Carlos Moreno 23:47

April 10, 2005

Thread Author Time
Re: Question on triggers and plpgsql Tom Lane 03:21
pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 11:52
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin Tony Caduto 14:37
Re: subselect query time and loops problem pankaj naug 14:54
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin Tom Lane 16:27
Re: subselect query time and loops problem Ragnar Hafstað 17:29

April 11, 2005

Thread Author Time
Re: [GENERAL] Problems with Set Returning Functions (SRFs) Michael Fuhr 02:06
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 08:48
Re: Getting the output of a function used in a where clause PFC 08:51
Re: [SQL] Problems with Set Returning Functions (SRFs) Sean Davis 10:07
How to Port Oracle's user defined "Package" into Postgres 8.0.1. Dinesh Pandey 13:39
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin Tom Lane 14:05
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 15:25
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin Tom Lane 16:20
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 16:32
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin Tom Lane 16:42
Update aborted if trigger function fails? Carlos Moreno 20:29
OpenFTS Dan Feiveson 20:38
PGCrypto: Realworld scenario and advice needed Moran.Michael 21:18
Query runs very slowly in Postgres, but very fast in other DBMS Andrus Moor 21:43
Re: PGCrypto: Realworld scenario and advice needed Joe Conway 22:26

April 12, 2005

Thread Author Time
Re: Getting the output of a function used in a where clause Bill Lawrence 01:25
Re: Query runs very slowly in Postgres, but very fast in other DBMS Ezequiel Tolnay 05:36
Re: Query runs very slowly in Postgres, but very fast in other DBMS Tom Lane 05:43
Re: Query runs very slowly in Postgres, but very fast in other DBMS Krasimir Dimitrov 06:33
Re: Update aborted if trigger function fails? Richard Huxton 07:30
Re: OpenFTS Oleg Bartunov 07:30
Re: Query runs very slowly in Postgres, but very fast in other DBMS Andrus 10:09
operating "inet" type Ilya A. Kovalenko 12:34
Re: Getting the output of a function used in a where clause Scott Marlowe 13:55
Re: Update aborted if trigger function fails? Carlos Moreno 14:55
Re: Update aborted if trigger function fails? Andrew Sullivan 15:17
Re: Query runs very slowly in Postgres, but very fast in other DBMS Dan Feiveson 15:18
Re: Update aborted if trigger function fails? Carlos Moreno 15:47
max question A. R. Van Hook 17:24
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 18:34
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 18:41
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin Tom Lane 18:45
Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin PFC 18:54
Re: getting count for a specific querry Vivek Khera 19:29
Re: Query history file Vivek Khera 19:33
Re: getting count for a specific querry Scott Marlowe 20:23
Re: getting count for a specific querry Vivek Khera 20:32
Re: getting count for a specific querry Scott Marlowe 20:42

April 13, 2005

Thread Author Time
ignore single character in SELECT query? jspring 02:46
Re: Getting the output of a function used in a where clause Bill Lawrence 03:46
Re: max question Tom Lane 04:46
Re: ignore single character in SELECT query? Greg Stark 04:56
Re: ignore single character in SELECT query? Dinesh Pandey 04:58
Re: max question Dinesh Pandey 05:02
Re: Getting the output of a function used in a where clause Bill Lawrence 06:08
Re: operating "inet" type Bruno Wolff III 13:14
Re: max question Bruno Wolff III 13:20
can a function return a virtual table? Kai Hessing 13:44
SQL subquery (count distinct) - Any Ideas? Matt Fulford 17:28

April 14, 2005

Thread Author Time
Re: SQL group select question Ezequiel Tolnay 09:20
Very low performance on table with only 298 rows Andreas Joseph Krogh 10:48
Re: Very low performance on table with only 298 rows Richard Huxton 11:28
dynamic 'INSERT' query? Dinesh Pandey 11:37
Re: Very low performance on table with only 298 rows Andreas Joseph Krogh 11:53
Re: dynamic 'INSERT' query? Sean Davis 11:59
Re: dynamic 'INSERT' query? Dinesh Pandey 12:03
Prepared query ? Dinesh Pandey 14:28
Re: dynamic 'INSERT' query? Tom Lane 14:53
Re: Prepared query ? 📎 Frank Bax 14:54
Re: dynamic 'INSERT' query? Dinesh Pandey 14:57
Re: Prepared query ? Dinesh Pandey 14:58
Re: Prepared query ? Richard Huxton 14:58
Re: Prepared query ? Dinesh Pandey 15:03
row-attribute in EXPLAIN-output doesn't match count(*) Andreas Joseph Krogh 16:38
Re: Very low performance on table with only 298 rows PFC 17:08
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andrew Sullivan 17:10
Re: row-attribute in EXPLAIN-output doesn't match count(*) Richard Huxton 17:12
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andreas Joseph Krogh 17:21
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andrew Sullivan 17:33
Re: PGCrypto: Realworld scenario and advice needed Moran.Michael 17:36
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andreas Joseph Krogh 17:54
Re: row-attribute in EXPLAIN-output doesn't match count(*) Richard Huxton 18:48
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andrew Sullivan 18:56
Re: row-attribute in EXPLAIN-output doesn't match count(*) Alvaro Herrera 19:04
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andrew Sullivan 19:08
Re: row-attribute in EXPLAIN-output doesn't match count(*) Greg Stark 19:44
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andreas Joseph Krogh 19:57
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andrew Sullivan 20:44
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andreas Joseph Krogh 21:15
Re: row-attribute in EXPLAIN-output doesn't match count(*) Carlos Moreno 22:24
Re: row-attribute in EXPLAIN-output doesn't match count(*) Tom Lane 23:20
Re: row-attribute in EXPLAIN-output doesn't match count(*) Tom Lane 23:26

April 15, 2005

Thread Author Time
CREATE USER in side a TRIGGER FUNCTION shaun 03:30
Re: row-attribute in EXPLAIN-output doesn't match count(*) Greg Stark 05:25
EXCEPTION handling in PL/pgSQL. Dinesh Pandey 05:35
Re: row-attribute in EXPLAIN-output doesn't match count(*) Tom Lane 05:48
Salam Kenal Rizal 06:33
force command execution drdani 08:33
Combining values in a column Stephen Quinney 09:22
Re: Combining values in a column Sean Davis 10:12
send mail from Postgres using PLTCLU language. Dinesh Pandey 12:47
[No subject] TJ O'Donnell 12:52
Re: send mail from Postgres using PLTCLU language. Dinesh Pandey 14:40
Re: row-attribute in EXPLAIN-output doesn't match count(*) Markus Schaber 16:22
Re: row-attribute in EXPLAIN-output doesn't match count(*) Markus Schaber 16:24
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andreas Joseph Krogh 16:26
Re: row-attribute in EXPLAIN-output doesn't match count(*) Markus Schaber 16:34
Re: row-attribute in EXPLAIN-output doesn't match count(*) Andreas Joseph Krogh 17:05
Re: How to Port Oracle's user defined "Package" into Postgres 8.0.1. CoL 21:58

April 16, 2005

Thread Author Time
Nested Sets A. Kulikov 12:31
Re: Nested Sets Troels Arvin 13:04
Re: Nested Sets A. Kulikov 14:28
Re: Nested Sets Andrew Sullivan 18:14
Re: Nested Sets Troels Arvin 20:02
Re: Nested Sets Christopher Browne 21:34

April 18, 2005

Thread Author Time
Error handling in pltcl Dinesh Pandey 03:50
Re: Error handling in pltcl Michael Fuhr 04:32
Re: Error handling in pltcl Dinesh Pandey 04:40
"pltcl" function. Dinesh Pandey 06:31
btree and is null in a static expression KÖPFERL Robert 07:23
user connection over tcp Frank Habermann 13:31
How to add 1 hour in a date or time stamp? Dinesh Pandey 13:38
Re: user connection over tcp Sean Davis 13:42
Re: user connection over tcp Dinesh Pandey 13:47
Re: [SQL] How to add 1 hour in a date or time stamp? Sean Davis 13:50
Re: [SQL] How to add 1 hour in a date or time stamp? Larry Rosenman 13:53
Re: user connection over tcp Frank Habermann 13:57
Re: [SQL] How to add 1 hour in a date or time stamp? Achilleus Mantzios 14:39
Re: outer join in ms query Jeff Eckermann 14:51
Re: outer join in ms query Philippe Lang 15:13
'Select INTO" in Execute (dynamic query ) Dinesh Pandey 16:04
Re: 'Select INTO" in Execute (dynamic query ) Tom Lane 17:26
User Defined Functions Errors A. Kulikov 18:32
Re: User Defined Functions Errors Michael Fuhr 19:07
About "Alter table... alter column.. TYPE ... " Ying Lu 20:38
Re: About "Alter table... alter column.. TYPE ... " Rod Taylor 21:09
tsearch2 Dan Feiveson 21:19
Re: tsearch2 Oleg Bartunov 22:19

April 19, 2005

Thread Author Time
Function declaration A. Kulikov 00:28
Re: Function declaration Sean Davis 01:20
Re: Getting the output of a function used in a where clause Rod Taylor 02:00
Re: SQL subquery (count distinct) - Any Ideas? Rod Taylor 02:19
Re: can a function return a virtual table? Michael Fuhr 02:43
Re: Getting the output of a function used in a where clause Tom Lane 02:59
How to select from many database ?? Art - Feping 03:13
Re: CREATE USER in side a TRIGGER FUNCTION Michael Fuhr 03:57
Re: Getting the output of a function used in a where clause Bill Lawrence 04:08
Re: "pltcl" function. Michael Fuhr 04:50
Re: SQL group select question Ramakrishnan Muralidharan 05:03
Re: SQL subquery (count distinct) - Any Ideas? Ramakrishnan Muralidharan 07:12
Re: User Defined Functions Errors KÖPFERL Robert 07:23
Re: can a function return a virtual table? KÖPFERL Robert 07:34
"Money" Data Type Problem sreejith s 07:37
Re: Getting the output of a function used in a where clause PFC 07:44
select the last post etur 08:50
Query about SQL in PostgreSQL Muhammad Nadeem Ashraf 09:48
Re: Query about SQL in PostgreSQL Reinoud van Leeuwen 09:58
Re: Query about SQL in PostgreSQL KÖPFERL Robert 09:59
Re: Query about SQL in PostgreSQL Sean Davis 10:16
Re: Query about SQL in PostgreSQL Thomas Kellerer 10:35
Re: Query about SQL in PostgreSQL Richard Huxton 10:58
Re: can a function return a virtual table? Bruno Wolff III 11:11
Re: Query about SQL in PostgreSQL Andrew Sullivan 13:25
Re: "Money" Data Type Problem Stephan Szabo 13:59
trying to do an update a bit confused. Joel Fradkin 14:06
Re: Query about SQL in PostgreSQL Jeff Eckermann 14:17
Re: DateAdd function ? Jeff Eckermann 14:23
Re: Query about SQL in PostgreSQL Jeff Eckermann 14:25
Re: DateAdd function ? Tom Lane 14:37
Re: trying to do an update a bit confused. KÖPFERL Robert 14:43
Coming from Oracle SQL Veronica L Bounmixay 15:37
Re: tsearch2 Dan Feiveson 15:37
Debet-Credit-Balance Calculation Muhyiddin A.M Hayat 16:47
Re: trying to do an update a bit confused. Joel Fradkin 16:57
Re: tsearch2 Oleg Bartunov 17:43
Re: trying to do an update a bit confused. Jaime Casanova 23:03

April 20, 2005

Thread Author Time
Re: Debet-Credit-Balance Calculation Mihail Nasedkin 02:28
Re: Debet-Credit-Balance Calculation Christopher Browne 03:14
Re: Debet-Credit-Balance Calculation Ramakrishnan Muralidharan 04:39
Re: can a function return a virtual table? Kai Hessing 07:23
Re: 'Select INTO" in Execute (dynamic query ) Ramakrishnan Muralidharan 10:21
How to configure postgresql to accept TCP/IP connections amit kumar awasthi 12:31
Function to either return one or all records KÖPFERL Robert 12:41
Re: Debet-Credit-Balance Calculation Muhyiddin A.M Hayat 12:50
Re: Debet-Credit-Balance Calculation Muhyiddin A.M Hayat 12:55
Re: Debet-Credit-Balance Calculation Chris Browne 13:43
Odd error message (" hash indexes do not support whole-index scans") Marinos Yannikos 15:23
Re: Odd error message (" hash indexes do not support whole-index scans") Tom Lane 16:02
Query question Stéphane RIFF 16:11
Re: Query question Franco Bruno Borghesi 17:35
Re: Function to either return one or all records Tambet Matiisen 20:02
Re: Function to either return one or all records Tom Lane 21:06

April 21, 2005

Thread Author Time
checking pgsql functions Enrico Weigelt 02:35
Re: checking pgsql functions Tom Lane 03:25
Re: checking pgsql functions Michael Fuhr 03:39
Re: Function to either return one or all records KÖPFERL Robert 06:43
Re: Function to either return one or all records Tambet Matiisen 07:34

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30