pgsql-sql - September 2004

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 5 6 7 8 9 10 11 12 13 15 16 17 18 19 20 21 22 23 24 26 27 28 29 30

Sept. 1, 2004

Thread Author Time
Re: casting BOOL to somthng sad 04:22
Re: casting BOOL to somthng sad 04:29
Re: casting BOOL to somthng Stephan Szabo 05:24
Re: casting BOOL to somthng sad 05:41
Re: casting BOOL to somthng sad 05:55
Re: casting BOOL to somthng sad 06:27
Re: casting BOOL to somthng Michael Glaesemann 06:38
casting UNKNOWN to REGCLASS sad 06:43
Re: casting BOOL to somthng Peter Eisentraut 06:59
Re: casting BOOL to somthng Michael Glaesemann 07:03
Re: casting BOOL to somthng Stephan Szabo 07:16
Re: casting BOOL to somthng Stephan Szabo 07:22
Re: casting BOOL to somthng Geoffrey 10:25
German "umlaut insensitive" query Robert Strötgen 14:01
Re: casting BOOL to somthng Tom Lane 14:19
Re: casting BOOL to somthng Stephan Szabo 14:33
Re: German "umlaut insensitive" query Michael Kleiser 14:36
Extracting fieldnames from a TABLE Erik Wasser 15:14
Re: German "umlaut insensitive" query Robert Strötgen 15:17
Re: colored PL with emacs John DeSoi 15:57
Re: Extracting fieldnames from a TABLE Thomas F.O'Connell 16:28
Defining Field Types with view Traci Sumpter 20:27
Re: Defining Field Types with view Tom Lane 22:41

Sept. 2, 2004

Thread Author Time
copy old column's values to new column ogjunk-pgjedan 13:16
Re: PRIMARY KEY and INDEX Achilleus Mantzios 13:50
Re: copy old column's values to new column Bruno Wolff III 13:51
Re: Complicated "group by" question Jeff Boes 14:39
Re: PRIMARY KEY and INDEX Devrim GUNDUZ 14:48
PRIMARY KEY and INDEX Nosyman 16:58

Sept. 3, 2004

Thread Author Time
HOW TO HANDLE ZEROS IN DATE FIELD? James M Doherty 14:36

Sept. 5, 2004

Thread Author Time
Full access to a DB with a second user? Erik Wasser 12:53
Re: Storing properties in a logical way. Pierre-Frédéric Caillaud 17:51
INFORMATION_SCHEMA and foreign keys Troels Arvin 22:56
Re: INFORMATION_SCHEMA and foreign keys Stephan Szabo 23:29

Sept. 6, 2004

Thread Author Time
Re: INFORMATION_SCHEMA and foreign keys Tom Lane 02:13
Storing properties in a logical way. Daniel M. 03:42
Re: Full access to a DB with a second user? Oliver Elphick 06:24
How to rename a constraint/trigger?? Andrei Bintintan 14:03
Re: Storing properties in a logical way. Daniel M. 19:37
When a table was last ANALYZEd Troels Arvin 20:30

Sept. 7, 2004

Thread Author Time
Isnumeric function? Theo Galanakis 05:44
Re: Isnumeric function? Oliver Elphick 06:05
Problem with LATIN1 characters from Perl-DBI Andreas Joseph Krogh 12:06
Re: Problem with LATIN1 characters from Perl-DBI Andreas Joseph Krogh 13:53
Problem with returning setof record oliverp21 17:13
Re: Problem with returning setof record Richard Huxton 17:35
SQL99 "with recursive" question Thomas Wegner 23:38

Sept. 8, 2004

Thread Author Time
Re: Isnumeric function? Josh Berkus 16:47
Re: [SQL] How to rename a constraint/trigger?? Josh Berkus 17:05
Re: Isnumeric function? Oliver Elphick 17:20
Re: Isnumeric function? Josh Berkus 17:48
Re: Isnumeric function? Oliver Elphick 18:11
aggregate function stddev Kemin Zhou 21:11
Re: Isnumeric function? Theo Galanakis 23:39
Re: Isnumeric function? Tom Lane 23:57

Sept. 9, 2004

Thread Author Time
Re: Isnumeric function? Theo Galanakis 00:02
check for circular references in a 2-table heirachy Terence Kearns 01:43
Re: Isnumeric function? Thomas Swan 01:58
Re: Isnumeric function? Greg Stark 03:48
Query Plan Theo Galanakis 05:30
[No subject] Theo Galanakis 07:32
Re: Query Plan Richard Huxton 08:28
Re: Isnumeric function? Jeff Eckermann 14:02
Datetime conversion in WHERE clause Philippe Lang 14:23
Re: Isnumeric function? Passynkov, Vadim 15:01
PL/pgSQL Function Problem the inquirer 17:49
Re: aggregate function stddev Josh Berkus 18:37
Re: Datetime conversion in WHERE clause Josh Berkus 18:42
Re: Isnumeric function? Josh Berkus 18:46
Using UPDATE FROM Collin Peters 19:54

Sept. 10, 2004

Thread Author Time
Re: Isnumeric function? Theo Galanakis 00:20
Re: Isnumeric function? Josh Berkus 02:21
Re: Isnumeric function? Theo Galanakis 02:50
Re: Isnumeric function? sad 04:48
Re: Isnumeric function? Achilleus Mantzios 05:39
Re: Isnumeric function? Greg Stark 06:43
Re: Isnumeric function? Greg Stark 07:02
Re: Isnumeric function? Tom Lane 13:59
Re: Isnumeric function? Greg Stark 15:33
CREATE RULE ignored, what did I do wrong andrew 21:36
Re: aggregate function stddev Bruce Momjian 21:48

Sept. 11, 2004

Thread Author Time
Re: HOW TO HANDLE ZEROS IN DATE FIELD? Michael Glaesemann 05:44
Re: PL/pgSQL Function Problem Tom Lane 06:03
Re: Using UPDATE FROM Tom Lane 06:17
Re: [SQL] PL/pgSQL Function Problem Michalis Kabrianis 06:22
Re: CREATE RULE ignored, what did I do wrong Tom Lane 06:42
Re: HOW TO HANDLE ZEROS IN DATE FIELD? Michael Glaesemann 12:57
Re: PL/pgSQL Function Problem Doug McNaught 13:55
create unique index schema.index_name on table (column)? m0ntar3 20:42

Sept. 12, 2004

Thread Author Time
Re: create unique index schema.index_name on table (column)? Michael Glaesemann 05:48
Re: create unique index schema.index_name on table (column)? Michael Glaesemann 05:54
Re: create unique index schema.index_name on table (column)? Tom Lane 05:55
Re: create unique index schema.index_name on table (column)? mØntar3 20:33

Sept. 13, 2004

Thread Author Time
what is maximum size of "text" datatype in postgres? Smit 08:35
Re: what is maximum size of "text" datatype in postgres? Christopher Browne 09:31
Interpolation and extrapolation in SQL David Garamond 15:03
Re: Interpolation and extrapolation in SQL Tom Lane 15:16
Re: CREATE RULE ignored, what did I do wrong andrew 18:13
Difficulties to use a Set Returning Function on a join Alvaro Nunes Melo 22:03

Sept. 15, 2004

Thread Author Time
explain analyze results are different for each iteration Robert Davis 01:21
Re: explain analyze results are different for each iteration Gregory S. Williamson 01:33
Re: explain analyze results are different for each iteration Stephan Szabo 02:07
implementing an out-of-transaction trigger Iain 03:03
Re: sleep function Sanjay Singh 09:22
Preserving column order when recreating table. Stef 12:24
Re: Preserving column order when recreating table. Andrew Sullivan 13:19
Re: Preserving column order when recreating table. Stef 14:22
Re: Preserving column order when recreating table. Andrew Sullivan 14:42
Re: Preserving column order when recreating table. Stef 15:07
Re: Preserving column order when recreating table. Andrew Sullivan 15:36
Re: implementing an out-of-transaction trigger Mike Rylander 16:03

Sept. 16, 2004

Thread Author Time
Re: implementing an out-of-transaction trigger Iain 02:02
Re: implementing an out-of-transaction trigger Greg Stark 03:57
Re: implementing an out-of-transaction trigger Iain 05:15
PL/pgSQL multidimension (matrix) array in function Sergio Fantinel 17:10
CREATE TABLE AS SELECT.... Arash Zaryoun 20:57

Sept. 17, 2004

Thread Author Time
How to check postgres running or not ? 📎 Sandeep Gaikwad 05:18
Implicit Transactions Chip Gobs 14:44
1-byte integers stig erikson 21:40

Sept. 18, 2004

Thread Author Time
Sequence of SQL command execution involving triggers and stored procedures. Omkar Rath 04:54
Re: 1-byte integers Greg Stark 15:39
Re: Sequence of SQL command execution involving triggers and stored procedures. Tom Lane 16:39
Re: How to check postgres running or not ? Christopher Browne 17:20
Re: How to check postgres running or not ? Gaetano Mendola 18:36

Sept. 19, 2004

Thread Author Time
Re: How to check postgres running or not ? Worik 01:57
Re: How to check postgres running or not ? Geoffrey 12:01
ORDER BY and NULLs T E Schmitz 14:57
Re: ORDER BY and NULLs terry 15:17
Re: How to check postgres running or not ? Jeff Eckermann 16:08
Re: ORDER BY and NULLs Jean-Luc Lachance 16:19
Re: How to check postgres running or not ? Tom Lane 16:25
Re: ORDER BY and NULLs T E Schmitz 16:36
Re: How to check postgres running or not ? Andrew Sullivan 16:57
Re: ORDER BY and NULLs Tom Lane 16:58
Re: How to check postgres running or not ? Tom Lane 17:12
Re: ORDER BY and NULLs T E Schmitz 17:18
Re: ORDER BY and NULLs Greg Stark 18:37
Re: ORDER BY and NULLs Tom Lane 19:00
Re: ORDER BY and NULLs T E Schmitz 20:22
Re: ORDER BY and NULLs Tom Lane 20:30
Re: ORDER BY and NULLs T E Schmitz 20:50
Re: How to check postgres running or not ? Gaetano Mendola 20:57
Re: How to check postgres running or not ? Gaetano Mendola 21:01

Sept. 20, 2004

Thread Author Time
Re: How to check postgres running or not ? Andrew Sullivan 00:20
Re: How to check postgres running or not ? Worik 00:34
Re: ORDER BY and NULLs Greg Stark 00:51
Re: How to check postgres running or not ? Worik 01:04
Re: How to check postgres running or not ? Tom Lane 01:11
Re: How to check postgres running or not ? Christopher Browne 01:33
Re: How to check postgres running or not ? Arne Stoelck 02:33
Test for file exists? Richard Sydney-Smith 03:16
Re: How to check postgres running or not ? Reiner Dassing 07:20
Re: ORDER BY and NULLs T E Schmitz 08:04
Re: How to check postgres running or not ? Gaetano Mendola 10:05
Re: How to check postgres running or not ? Peter Eisentraut 11:47
Re: How to check postgres running or not ? Bruce Momjian 12:19
Re: Implicit Transactions Bruce Momjian 12:34
Re: How to check postgres running or not ? Theodore Petrosky 13:46
COUNT(*) to find records which have a certain number of dependencies ? T E Schmitz 15:14
Re: COUNT(*) to find records which have a certain number of T E Schmitz 16:19
Re: Test for file exists? Josh Berkus 16:30
Re: COUNT(*) to find records which have a certain number of Rod Taylor 16:31
Re: COUNT(*) to find records which have a certain number of Martin Knipper 16:44
Re: COUNT(*) to find records which have a certain number of T E Schmitz 17:59
Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark 18:32
Re: COUNT(*) to find records which have a certain number of Greg Stark 18:33
JOIN performance Dean Gibson (DB Administrator) 19:24
Re: COUNT(*) to find records which have a certain number of T E Schmitz 19:50
Help with function CHRIS HOOVER 20:36
Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark 20:45
Re: Help with function Stephan Szabo 20:51
Re: COUNT(*) to find records which have a certain number of Chester Kustarz 20:55
unsubscribe Ramiro Batista da Luz 21:30
Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ? Greg Stark 21:39
Re: CREATE TABLE AS SELECT.... Andrew Hammond 21:56
Re: JOIN performance Tom Lane 23:06
Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ? Tom Lane 23:23

Sept. 21, 2004

Thread Author Time
Re: JOIN performance Dean Gibson (DB Administrator) 00:10
Re: JOIN performance Tom Lane 00:54
Problem with functions Michael Snodgrass 01:36
Re: JOIN performance Dean Gibson (DB Administrator) 01:41
Re: JOIN performance Chester Kustarz 04:09
Re: JOIN performance Tom Lane 04:10
Re: JOIN performance Dean Gibson (DB Administrator) 04:41
Re: PL/pgSQL multidimension (matrix) array in function Joe Conway 04:44
Re: JOIN performance Tom Lane 05:19
[ocpfree] Info Needed about OCA birdy edwards 05:55
Re: JOIN performance Dean Gibson (DB Administrator) 06:24
Difference in DATEs Dean Gibson (DB Administrator) 07:38
postgres rpm Nagaraj GS 07:46
degradation in performance Alain Reymond 11:27
Re: degradation in performance Martin Knipper 11:32
Re: degradation in performance Stephan Szabo 12:25
Re: degradation in performance Pierre-Frédéric Caillaud 12:41
Re: Difference in DATEs Tom Lane 14:01
Re: Help with function CHRIS HOOVER 14:23
Re: Help with function Stephan Szabo 15:25
Porting problem from Informix to Postgres... Marco Gaiarin 15:42
Re: Difference in DATEs Dean Gibson (DB Administrator) 15:53
Re: Different topic Dean Gibson (DB Administrator) 16:19

Browse Archives

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