pgsql-sql - October 2003

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Oct. 1, 2003

Thread Author Time
Re: Temporary tables George A.J 03:17
Unsubscribe Rute Solipa 09:28
Unsubscribe dnaren 09:35
Unsubscribe Mark Roberts 09:44
Determining Inheritance Gordon Ross 09:51
Creating Index CN 11:47
Re: Creating Index Peter Eisentraut 12:21
Re: Determining Inheritance Tom Lane 14:26
Link Oracle tables in Postgre OpenGis 15:24
Re: Creating Index CN 15:25
Re: Link Oracle tables in Postgre Richard Huxton 15:43
Re: Creating Index Tom Lane 15:58
Re: Creating Index Rod Taylor 16:08
Re: Link Oracle tables in Postgre Josh Berkus 16:59
Re: Creating Index CN 17:02
Re: Creating Index Stephan Szabo 18:15
[No subject] Vishal Charan (IT Fiji) 20:42
inherited indexes ritchie turner 21:54
Regarding decode function Buchi_Babu 22:43

Oct. 2, 2003

Thread Author Time
help with rule and notification Theodore Petrosky 02:10
help with rule and notification Theodore Petrosky 02:15
Re: Creating Index CN 02:40
Re: help with rule and notification CN 02:50
Re: help with rule and notification Tom Lane 03:10
Re: Creating Index Tom Lane 03:18
Re: Creating Index Stephan Szabo 05:37
output Popeanga Marian 08:52
Re: output Richard Huxton 11:01
Re: output Popeanga Marian 11:09
Re: Creating Index CN 11:36
Re: output Richard Huxton 12:17
Re: help with rule and notification Theodore Petrosky 12:34
Re: output Tom Lane 14:35
Re: Creating Index Stephan Szabo 14:55
Re: Creating Index CN 15:50
Re: Creating Index Tom Lane 17:58
How to figure out when was a table created David B 23:01

Oct. 3, 2003

Thread Author Time
Re: Creating Index CN 02:06
Re: output Popeanga Marian 04:09
Re: Creating Index CN 04:12
Re: How to figure out when was a table created achill 06:33
Data type conversion Jan Pips 07:23
Re: How to figure out when was a table created Bruno Wolff III 11:54
Re: How to figure out when was a table created btober 12:12
HeapTuple->t_tableOid==0 after SPI_exec achill 12:56
Bug in psql - Postgresql 7.3.1? John B. Scalia 13:18
Re: HeapTuple->t_tableOid==0 after SPI_exec Tom Lane 14:43
Re: HeapTuple->t_tableOid==0 after SPI_exec Tom Lane 15:03
Re: HeapTuple->t_tableOid==0 after SPI_exec achill 15:04
Re: Creating Index Tom Lane 15:26
Re: Data type conversion Jeff Boes 16:20
Re: Bug in psql - Postgresql 7.3.1? Wei Weng 19:37
Re: Data type conversion Bruno Wolff III 19:44
Re: Bug in psql - Postgresql 7.3.1? Josh Berkus 19:45
Re: Bug in psql - Postgresql 7.3.1? Bruno Wolff III 19:47
Re: Bug in psql - Postgresql 7.3.1? Josh Berkus 20:16
Re: Bug in psql - Postgresql 7.3.1? Tom Lane 20:27
function with variable length of parameters Wei Weng 22:34

Oct. 4, 2003

Thread Author Time
Re: Regarding decode function Doris Bernloehr 00:50
Running tally Christopher Kings-Lynne 09:56

Oct. 6, 2003

Thread Author Time
FK Constraints, indexes and performance ow 00:29
Re: FK Constraints, indexes and performance Tom Lane 04:40
Re: FK Constraints, indexes and performance Peter Childs 04:59
Bad encoding in URL HR 10:45
Converting Query from MS SQL Kumar 13:04
row and column transposition teknokrat 13:28
Re: output Popeanga Marian 13:32
Re: Converting Query from MS SQL Richard Huxton 13:52
PG equivalent to Sybase varbinary Bill Pfeiffer 14:40
Multiple table join Louise Cofield 16:26
suggestion needed for implementation Wei Weng 16:29
create new field Chris Faulkner 16:35
Re: Multiple table join Louise Cofield 16:35
Re: Multiple table join Bruno Wolff III 16:38
Re: Multiple table join Dan Langille 16:39
Re: create new field Josh Berkus 16:44
Re: create new field Bruno Wolff III 16:56

Oct. 7, 2003

Thread Author Time
Re: FK Constraints, indexes and performance ow 00:37
privileges sad 07:07
Problem with Escape charactor Kumar 12:57
Interest query plan pginfo 15:00
Re: Interest query plan pginfo 15:14
Re: Interest query plan pginfo 15:36
Re: Interest query plan Tomasz Myrta 16:17
Re: Interest query plan Tomasz Myrta 17:11
Re: Problem with Escape charactor George Weaver 17:16
Re: privileges Josh Berkus 17:43
Re: row and column transposition Bruno Wolff III 18:44
Re: Bad encoding in URL Theodore Petrosky 19:11
Re: Bad encoding in URL George Weaver 19:18

Oct. 8, 2003

Thread Author Time
security definer function Tomek 07:20
Re: PG equivalent to Sybase varbinary Richard Huxton 08:45
security definer function Tomasz Myrta 10:36
Possible to have array as input paramter for a function? Kumar 10:47
Re: Possible to have array as input paramter for a function? George Weaver 12:50
Re: PG equivalent to Sybase varbinary Bill Pfeiffer 13:44
Re: Possible to have array as input paramter for a function? George Weaver 14:06
Re: Oracle 'connect by prior' now eaiser in 7.3? Thomas Wegner 19:38
UPDATE one table with values from another Dan Langille 22:10
Re: UPDATE one table with values from another Josh Berkus 23:37

Oct. 9, 2003

Thread Author Time
Re: UPDATE one table with values from another Stephan Szabo 00:12
Re: UPDATE one table with values from another Dan Langille 03:41
[postgres] Copy Timestamp NULL Danny Tramnitzke 07:55
about postgre SQL download Illusiontechnologies 10:09
Selecting rows as if they were columns? Kurt Overberg 13:14
Re: Selecting rows as if they were columns? Harald Fuchs 13:40
Re: Jan Wieck 13:45
select roberto 15:09
Re: select Janko Richter 16:58
Re: Selecting rows as if they were columns? Josh Berkus 17:14
get diagnostics not supported by ecpg? Slava Gorski 17:29
Re: Selecting rows as if they were columns? Richard Huxton 17:57
Re: [SQL] SQL query problem Bruno Wolff III 19:05
SQL query problem Marek Lewczuk 19:52
Re: SQL query problem Karsten Hilbert 21:33

Oct. 10, 2003

Thread Author Time
Re: SQL query problem Stuart Barbee 03:51
smart(er) column aliases Iain Sinclair 05:51
Re: SQL query problem (many table in FROM statement and many LEFT JOIN's) Marek Lewczuk 07:53
Re: Oracle 'connect by prior' now eaiser in 7.3? Thomas Wegner 08:09
Re: [SQL] SQL query problem (many table in FROM statement and many LEFT JOIN's) Richard Huxton 08:13
Alias-Error Jost Richstein 08:40
HELP ME jagan reddy 11:46
monitor sessions Chris Faulkner 12:48
Inquiry From Form [pgsql] Bram 12:50
Re: monitor sessions Franco Bruno Borghesi 13:43
Re: [postgres] Copy Timestamp NULL Ian Barwick 19:08

Oct. 11, 2003

Thread Author Time
PL/PGSQL TUTORIAL Muhyiddin A.M Hayat 07:57
Re: PL/PGSQL TUTORIAL Richard Huxton 09:32
Re: PL/PGSQL TUTORIAL Richard Huxton 09:36
sql performance and cache Chris Faulkner 09:43
Re: sql performance and cache Christopher Kings-Lynne 10:11
Re: sql performance and cache Christopher Kings-Lynne 10:16
Re: [SQL] sql performance and cache Richard Huxton 10:39
Re: [SQL] sql performance and cache Chris Faulkner 11:12
Re: [SQL] sql performance and cache Christopher Kings-Lynne 11:26
Re: [SQL] sql performance and cache Christopher Kings-Lynne 11:26
Re: [SQL] sql performance and cache Richard Huxton 11:55
Re: Running tally Richard Huxton 18:43
Re: Running tally elein 19:49
Re: PL/PGSQL TUTORIAL Roberto Mello 23:47

Oct. 12, 2003

Thread Author Time
Re: [SQL] sql performance and cache Josh Berkus 21:31

Oct. 13, 2003

Thread Author Time
[postgres] Foreign Key Stefan Sturm 08:55
Re: [postgres] Foreign Key Alvar Freude 10:37
Re: [postgres] Foreign Key Stefan Sturm 10:47
Re: [postgres] Foreign Key Stefan Sturm 10:51
Re: [postgres] Foreign Key Stefan Sturm 10:54
Re: [postgres] Foreign Key Alvar Freude 10:56
Re: [postgres] Foreign Key Stefan Sturm 11:01
[postgres] Antwort von Microsoft auf Mail hier! Alvar Freude 12:18
Re: [postgres] Antwort von Microsoft auf Mail hier! Danny Tramnitzke 12:29
Re: [postgres] Antwort von Microsoft auf Mail hier! Alvar Freude 12:37
removing precision from timestamp (microseconds) .. Marc G. Fournier 14:04
Re: sql performance and cache johnnnnnn 16:19
Re: [postgres] Antwort von Microsoft auf Mail hier! Ian Barwick 17:15
Escaping the $1 parameter in stored procedures robert 20:18
SSL 2000info 20:27

Oct. 14, 2003

Thread Author Time
Re: [postgres] Antwort von Microsoft auf Mail hier! Cornelia Boenigk 07:20
Re: [SQL] SQL query problem (many table in FROM statement and many LEFT JOIN's) Tom Lane 14:35
Re: [SQL] sql performance and cache Tom Lane 16:14
Re: [SQL] sql performance and cache Wei Weng 16:48
Re: about postgre SQL download Richard Huxton 17:25
Re: [SQL] sql performance and cache scott.marlowe 17:26
Re: Oracle 'connect by prior' now eaiser in 7.3? Joe Conway 17:45
How to determine the current user Michael Brusser 18:05
Re: security definer function Peter Eisentraut 18:13
Re: sql performance and cache Rod Taylor 18:15
Re: get diagnostics not supported by ecpg? Peter Eisentraut 18:34
Re: How to determine the current user Sean Chittenden 19:14

Oct. 15, 2003

Thread Author Time
Create View Muhyiddin A.M Hayat 01:01
How can I produce the following desired result? aicean 02:09
Re: How can I produce the following desired result? Rod Taylor 02:27
Re: How can I produce the following desired result? aicean 03:02
Sorting problem George A.J 03:30
Re: Sorting problem Stephan Szabo 03:39
Re: Create View Richard Huxton 08:17
Re: about postgre SQL download Richard Huxton 13:17
Re: Escaping the $1 parameter in stored procedures robert 14:12
Re: How can I produce the following desired result? greg 14:48
Re: How can I produce the following desired result? Jean-Luc Lachance 15:36
Re: Sorting problem Jean-Luc Lachance 15:42
indexing timestamp fields teknokrat 15:56
Re: indexing timestamp fields Christopher Browne 16:21
Calc Muhyiddin A.M Hayat 19:59
Re: indexing timestamp fields teknokrat 20:25
Re: Calc Steve Crawford 20:31
Re: indexing timestamp fields Christopher Browne 21:31
SQL function to validate money input Zhao, Scott 21:46
Re: Calc Josh Berkus 22:15

Oct. 16, 2003

Thread Author Time
convert integer seconds to timestamp Wilson Fletcher 03:31
Re: convert integer seconds to timestamp Wilson Fletcher 03:39
Re: convert integer seconds to timestamp Wilson Fletcher 03:44
Re: Sorting problem R. van Twisk 06:25
Re: SQL function to validate money input Richard Huxton 12:50
Re: Alias-Error Tom Lane 14:43
Re: indexing timestamp fields Bruno Wolff III 16:56
Re: Calc Steve Crawford 17:35
Re: Calc Muhyiddin A.M Hayat 17:37
Add column with specific colid Olga Macias 17:59
Can't convert numeric to_char() in catenate function Yusuf 22:24
Postgres with OpenSSL 2000info 22:53

Browse Archives

Prev | Next