pgsql-sql since 2003-07-20 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 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
Re: Odd problems with create rule Jamie Lawrence 22:08
Re: Function index qeustion Tom Lane 23:41

July 26, 2003

Thread Author Time
Very strange 'now' behaviour in nested triggers. Denis Zaitsev 13:39
Re: Very strange 'now' behaviour in nested triggers. Richard Huxton 14:14
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 14:31
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 19:58
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 20:01

July 27, 2003

Thread Author Time
Re: Very strange 'now' behaviour in nested triggers. Richard Huxton 07:47
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 11:09
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 15:49

July 28, 2003

Thread Author Time
Re: Very strange 'now' behaviour in nested triggers. Roberto Mello 00:27
Re: Can a table have a reference to itself? Stephan Szabo 03:47
Using a compound primary key David Witham 03:59
join optimization problem Toby Tremayne 04:12
Re: Can a table have a reference to itself? Tom Lane 05:31
Re: Using a compound primary key Tom Lane 05:45
Re: Problem using Subselect results Bruno Wolff III 16:41
Re: Very strange 'now' behaviour in nested triggers. Dmitry Tkach 16:43
Re: Problem using Subselect results Josh Berkus 16:47
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 16:52
Re: Very strange 'now' behaviour in nested triggers. Dmitry Tkach 17:06
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 17:12
Re: Very strange 'now' behaviour in nested triggers. Dmitry Tkach 17:18
NEW and a subselect in a rule Denis Zaitsev 22:50

July 29, 2003

Thread Author Time
How can I to solute this problem? LEON 06:18
Re: How can I to solute this problem? Paul Thomas 07:23
unsubscribe [email protected] 📎 Subramaniam, Sankari (Cognizant) 11:07
Re: Problem using Subselect results oheinz 11:34
How can I to solute this problem? Christopher Browne 12:11
Re: How can I to solute this problem? Paul Thomas 12:37
Re: How can I to solute this problem? Achilleus Mantzios 13:23
unsubscribe Mark Roberts 14:04
length of recordset read through a cursor Knut P. Lehre 14:10
Re: Problem using Subselect results Tom Lane 15:00
Re: Problem using Subselect results Oliver Heinz 15:14
Unsubscribe Antony Gubert 15:14
Re: How can I to solute this problem? Achilleus Mantzios 16:09
transactions Viorel Dragomir 18:14
Re: transactions Josh Berkus 19:28
Does a the block of code within a stored procedure constitute a transaction? btober 20:16
Unsubscribe ww zz 20:46
Nonexistent NEW relation in some places of rules Denis Zaitsev 21:33
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 22:05
Re: Nonexistent NEW relation in some places of rules Tom Lane 22:32
Unsubscribe Vishal Charan (IT Fiji) 23:06

July 30, 2003

Thread Author Time
function returning setof performance question Mark Bronnimann 02:08
Re: Very strange 'now' behaviour in nested triggers. Bruce Momjian 02:20
Re: function returning setof performance question Rod Taylor 02:28
Re: function returning setof performance question Mark Bronnimann 02:57
Re: function returning setof performance question Joe Conway 03:51
time precision. Anagha Joshi 07:52
Re: Problem using Subselect results oheinz 08:52
Which cursor-related warnings should be errors? Peter Eisentraut 09:06
Re: time precision. Christoph Haller 09:08
Re: How can I to solute this problem? LEON 09:43
Re: [SQL] time precision. Stephan Szabo 09:45
now 7.2.3 - 7.3.3 A. Van Hook 10:06
Re: now 7.2.3 - 7.3.3 Peter Eisentraut 10:41
Re: How can I to solute this problem? Paul Thomas 11:25
select query that would join two databases Keith H.K. Lam (U1 Tech.) 11:28
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 13:48
Re: now 7.2.3 - 7.3.3 Tom Lane 15:19
ALTER TABLE ... DROP CONSTRAINT Elielson Fontanezi 15:52
Re: ALTER TABLE ... DROP CONSTRAINT Andrew Gould 16:07
Re: ALTER TABLE ... DROP CONSTRAINT Rod Taylor 16:21
Re: [SQL] ALTER TABLE ... DROP CONSTRAINT Chad Thompson 16:25
Re: [SQL] ALTER TABLE ... DROP CONSTRAINT George Weaver 16:45
Re: [SQL] function returning setof performance question Josh Berkus 17:28
Re: Problem using Subselect results Josh Berkus 18:08
Re: [SQL] ALTER TABLE ... DROP CONSTRAINT Rajesh Kumar Mallah 19:25
Re: Fwd: Bad Join moment - how is this happening? Josh Berkus 19:25
One to many query question Dave Dribin 19:35
Re: Fwd: Bad Join moment - how is this happening? Richard Huxton 19:36
Re: Fwd: Bad Join moment - how is this happening? Josh Berkus 19:38
Re: Fwd: Bad Join moment - how is this happening? Stephan Szabo 19:39
Fwd: Bad Join moment - how is this happening? Jamie Lawrence 20:07
Re: One to many query question Eric Clark 20:11
Re: One to many query question Dave Dribin 20:27
Re: Nonexistent NEW relation in some places of rules Denis Zaitsev 21:02
Re: One to many query question Richard Poole 21:12
Re: One to many query question Richard Huxton 21:19
Re: One to many query question Dmitry Tkach 21:26
Re: One to many query question Chad Thompson 21:28
Re: One to many query question Eric Clark 21:42
Re: One to many query question Dave Dribin 22:33

July 31, 2003

Thread Author Time
Unsubscribe 2000info 00:25
[No subject] Vishal Charan (IT Fiji) 01:18
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian 04:12
Re: One to many query question Christoph Haller 07:42
Re: NEW and a subselect in a rule Christoph Haller 08:00
Unsubscribe rute solipa 08:35

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