pgsql-sql since 2003-07-16 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 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 16, 2003

Thread Author Time
Datatype Conversion help Ramesh Kumar B 00:41
Help Me Ramesh Kumar B 01:17
Re: Non-Blocking Locks (i.e. Oracle NOWAIT) Ang Chin Han 03:17
Data Warehousing Rudi Starcevic 04:43
numerical sort on mixed alpha/numeric data Gary Stainburn 11:48
pg_dump "feature" Viorel Dragomir 13:41
Re: problem with temporary table. Jonathan Gardner 13:42
Re: numerical sort on mixed alpha/numeric data Dmitry Tkach 14:27
Re: pg_dump "feature" Tom Lane 14:29
Re: pg_dump "feature" Dmitry Tkach 14:33
Re: numerical sort on mixed alpha/numeric data Gary Stainburn 14:39
Re: pg_dump "feature" Viorel Dragomir 14:43
Re: column doesn't get calculated - updated floyds 15:04
Re: Data Warehousing Dani Oderbolz 15:27
"Truncate [ Table ] name [Cascade]"? Andreas 15:44
Re: numerical sort on mixed alpha/numeric data Bruno Wolff III 16:41
Re: column doesn't get calculated - update # 2 floyds 16:54
Re: numerical sort on mixed alpha/numeric data Bruno Wolff III 16:54
Re: column doesn't get calculated - update # 2 Barry Lind 17:44
Why do the two queries below return different results? Warren Little 20:52

July 17, 2003

Thread Author Time
relevance jtx 00:52
Join table with itself for heirarchial system? Benjamin Smith 01:34
Re: relevance Oleg Bartunov 02:37
Re: relevance Terence Kearns 02:51
Re: Recursive request ... Benoît Bournon 06:39
Re: Recursive request ... BenLaKnet 06:44
Re: relevance Rajesh Kumar Mallah 07:15
Re: relevance Terence Kearns 08:39
parse error for function def Terence Kearns 10:46
unique value - trigger? Gary Stainburn 11:56
Is it possible to connect to another database BenLaKnet 14:03
Re: Is it possible to connect to another database Adam Witney 14:05
Re: Is it possible to connect to another database Viorel Dragomir 14:06
Re: parse error for function def greg 14:19
Re: parse error for function def Dmitry Tkach 14:24
Re: NOT and AND problem terry 14:29
NOT and AND problem Richard Jones 14:29
Re: unique value - trigger? Dmitry Tkach 14:34
Re: NOT and AND problem Viorel Dragomir 14:34
Re: NOT and AND problem Dmitry Tkach 14:41
Re: NOT and AND problem terry 14:52
Re: NOT and AND problem Richard Jones 15:09
Re: parse error for function def Stephan Szabo 15:39
Re: unique value - trigger? Gary Stainburn 15:49
Re: unique value - trigger? Dmitry Tkach 16:03
Re: unique value - trigger? Richard Poole 16:05
Re: unique value - trigger? Richard Poole 16:09
Table Partitioning and Rules Girish Bajaj 17:20
Re: Recursive request ... Joe Conway 17:42
OR vs UNION Scott Cain 18:11
Re: Table Partitioning and Rules Richard Huxton 18:52
Re: OR vs UNION Josh Berkus 19:00
Re: Table Partitioning and Rules Josh Berkus 19:03
Re: OR vs UNION Scott Cain 19:18
Re: Table Partitioning and Rules Rod Taylor 19:22
Re: Table Partitioning and Rules Girish Bajaj 19:22
Re: OR vs UNION Tom Lane 19:24
Re: Table Partitioning and Rules Josh Berkus 19:38
Re: Table Partitioning and Rules Steve Crawford 19:39
Re: Table Partitioning and Rules Dmitry Tkach 19:42
Re: OR vs UNION terry 19:58
Re: parse error for function def Jonathan Gardner 21:37
Return a set of values from postgres Function Derrick Betts 22:30

July 18, 2003

Thread Author Time
Re: Recursive request ... Greg Stark 06:00
Re: Table Partitioning and Rules Greg Stark 06:15
Re: Table Partitioning and Rules Richard Huxton 07:06
(trigger function) -> ERROR: NEW used in non-rule query Terence Kearns 08:22
Re: (trigger function) -> ERROR: NEW used in non-rule query Richard Huxton 09:03
Re: (trigger function) -> ERROR: NEW used in non-rule query Terence Kearns 09:18
Re: (trigger function) -> ERROR: NEW used in non-rule query Richard Huxton 13:06
How to determine the currently logged on username Chris Travers 13:41
Re: How to determine the currently logged on username Richard Huxton 14:25
How access to array component Cristian Cappo 14:52
plpgsql strangeness with select into <variable> Reinoud van Leeuwen 15:24
Re: [HACKERS] plpgsql strangeness with select into <variable> Josh Berkus 16:14
Re: [HACKERS] plpgsql strangeness with select into <variable> Stephan Szabo 16:19
Re: (trigger function) -> ERROR: NEW used in non-rule query Josh Berkus 16:38
Re: (trigger function) -> ERROR: NEW used in non-rule query Dmitry Tkach 16:49
Re: plpgsql strangeness with select into <variable> Robert Treat 17:55
how to copy table to another database? Yudie 20:47
Re: how to copy table to another database? scott.marlowe 20:58
Re: how to copy table to another database? Dmitry Tkach 21:06
casting to arrays Mike Rylander 21:07
Re: casting to arrays Joe Conway 21:34
Re: ODBC query problem AGAIN Maksim Likharev 21:50
Re: casting to arrays Mike Rylander 22:29
Re: [GENERAL] ODBC query problem AGAIN Luis Magaña 22:42
Re: casting to arrays Joe Conway 22:47
Re: (trigger function) -> ERROR: NEW used in non-rule query Terence Kearns 23:13

July 19, 2003

Thread Author Time
Re: plpgsql strangeness with select into <variable> Philip Warner 14:23
Re: casting to arrays Greg Stark 23:11

July 20, 2003

Thread Author Time
Re: How access to array component Joe Conway 03:04
Re: min() and NaN Tom Lane 04:40
Re: column doesn't get calculated - updated Tom Lane 04:42
Re: Why do the two queries below return different results? Tom Lane 04:54
SECURITY DEFINER changes CURRENT_USER? Chris Travers 05:07
Re: min() and NaN Stephan Szabo 06:11
Re: changing an update via rules Stephan Szabo 06:15
Re: SECURITY DEFINER changes CURRENT_USER? Matthew Horoschun 06:19
Re: Return a set of values from postgres Function Stephan Szabo 06:20
Re: min() and NaN Stephan Szabo 06:26
Re: Join table with itself for heirarchial system? Oleg Bartunov 07:44

July 21, 2003

Thread Author Time
Re: inet versus text for ip addresses Bruce Momjian 03:47
Re: "Truncate [ Table ] name [Cascade]"? Wolfgang Slany 09:30
Why their is a limit in Postgresql (psql) Parameters..? 📎 vijaykumar M 10:29
Re: Why their is a limit in Postgresql (psql) Parameters..? Richard Huxton 11:42
Re: How to write this query! Richard Huxton 11:46
query or function jwsacksteder 12:10
Postgresql Temporary table scripts.. 📎 vijaykumar M 12:52
Re: Why their is a limit in Postgresql (psql) Parameters..? Rod Taylor 13:09
Re: avoid select expens_expr(col) like unneccessary calculations Bruce Momjian 15:23
Re: min() and NaN Jean-Luc Lachance 15:41
Re: min() and NaN Tom Lane 15:43
Re: Timestamp problem Barry Lind 18:55
Re: How access to array component Cristian Cappo A. 19:17

July 22, 2003

Thread Author Time
Re: OR vs UNION Bruce Momjian 00:32
Re: min() and NaN Bruce Momjian 01:34
Re: How access to array component Joe Conway 05:09
Re: min() and NaN Tom Lane 06:09
time delay function Girish Bajaj 07:59
Re: time delay function Christoph Haller 08:22
Re: time delay function Peter Eisentraut 09:34
Re: min() and NaN Michael Tibbetts 14:03
Re: How access to array component Cristian Cappo A. 14:19
Re: min() and NaN Bruce Momjian 16:14
slow query 📎 Markus Bertheau 17:07
Re: slow query Markus Bertheau 17:56
Re: min() and NaN Stephan Szabo 18:32
Re: min() and NaN Jean-Luc Lachance 18:50
Re: min() and NaN Bruce Momjian 18:59
Re: min() and NaN Tom Lane 19:33
Re: min() and NaN Bruce Momjian 20:19
obtuse plpgsql function needs Robert Treat 22:31
Re: obtuse plpgsql function needs Josh Berkus 23:21
Re: obtuse plpgsql function needs elein 23:33

July 23, 2003

Thread Author Time
rule causes nextval() to be invoked twice paul cannon 01:47
Re: rule causes nextval() to be invoked twice paul cannon 02:08
Re: rule causes nextval() to be invoked twice Tom Lane 04:41
Re: rule causes nextval() to be invoked twice A.Bhuvaneswaran 09:44
Problem using Subselect results oheinz 12:51
Re: obtuse plpgsql function needs Robert Treat 13:06
Re: obtuse plpgsql function needs Robert Treat 14:04
Re: rule causes nextval() to be invoked twice Dmitry Tkach 14:30
Can a table have a reference to itself? Oliver Duke-Williams 14:45
Re: slow query Markus Bertheau 15:32
Re: obtuse plpgsql function needs elein 18:12
Re: obtuse plpgsql function needs Josh Berkus 18:24
Re: obtuse plpgsql function needs Tom Lane 19:15
Re: obtuse plpgsql function needs elein 19:27
Re: obtuse plpgsql function needs greg 19:38
Re: time delay function Robert Treat 19:48
Re: obtuse plpgsql function needs Robert Treat 20:01
Re: obtuse plpgsql function needs Josh Berkus 20:11
TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat 20:13
strange "order by" request Frank Bax 20:45
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian 23:06
More plsql questions: updates on views Jamie Lawrence 23:31

July 24, 2003

Thread Author Time
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat 02:00
Re: obtuse plpgsql function needs Tom Lane 05:07
[No subject] Pavel Penak 06:46
Combine 'left outer join' and 'inner join' ext-thierry.templier 07:10
Problem using Subselect results oheinz 08:39
Re: Problem using Subselect results Christoph Haller 12:11
Re: Problem using Subselect results oheinz 13:01
Re: Problem using Subselect results Dmitry Tkach 14:54
PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Trent.Mera 15:52
PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Trent.Mera 17:29
Re: PostgreSQL or pl/psSQL equivalent to MS SQL Server's scott.marlowe 17:31
Re: min() and NaN Greg Stark 18:35
Re: min() and NaN Tom Lane 18:44
Re: obtuse plpgsql function needs elein 19:03
silly NULL question Dan Weeks 23:15
Re: silly NULL question Rod Taylor 23:25
Re: silly NULL question Dan Weeks 23:31

July 25, 2003

Thread Author Time
Equivalent to sql%rowcount or @@rowcount 📎 vijaykumar M 06:04
Re: Equivalent to sql%rowcount or @@rowcount Richard Huxton 08:05
[OT] Frontend recommendations ries 08:18
Re: Problem using Subselect results oheinz 09:01
Re: [OT] Frontend recommendations Richard Huxton 09:50
Re: [OT] Frontend recommendations Peter Childs 12:31
Query analyse Elielson Fontanezi 13:08
Re: Problem using Subselect results Tom Lane 13:45
Re: Problem using Subselect results Dmitry Tkach 14:23
Re: [OT] SUMMERY Frontend recommendations R. van Twisk 14:34
Re: Query analyse Stephan Szabo 15:49
Re: Query analyse Dmitry Tkach 16:05
locks and variable substitution gack 18:49
ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 19:09
Re: [SQL] ERROR: DefineIndex: index function must be marked iscachable Stephan Szabo 19:21
Re: ERROR: DefineIndex: index function must be marked iscachable Tomasz Myrta 19:22
Re: [SQL] ERROR: DefineIndex: index function must be Stephan Szabo 19:24
RES: [SQL] ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 19:27
Re: Query analyse Tom Lane 19:39
ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 19:43
Re: ERROR: DefineIndex: index function must be marked Stephan Szabo 19:47
Re: locks and variable substitution Eric Clark 19:57
RES: ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 20:20
Function index qeustion Jonathan Bartlett 20:26
Re: Odd problems with create rule Tomasz Myrta 21:08
Odd problems with create rule Jamie Lawrence 21:38

Browse Archives

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