pgsql-sql since 2003-10-07 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

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
Re: Can't convert numeric to_char() in catenate function Josh Berkus 23:04
Re: Can't convert numeric to_char() in catenate function Yusuf 23:26
Re: Postgres with OpenSSL Jordan S. Jones 23:26
Re: Postgres with OpenSSL Jordan S. Jones 23:37

Oct. 17, 2003

Thread Author Time
Re: Calc Muhyiddin A.M Hayat 01:38
Object description at Client Window Kumar 06:06
Re: Object description at Client Window Jordan S. Jones 06:20
Re: Object description at Client Window Kumar 08:44
Re: Object description at Client Window Richard Huxton 09:24
[postgres] IPv6-Datentyp(en) in PostgreSQL? stephan.rupp 10:39
Re: [postgres] IPv6-Datentyp(en) in PostgreSQL? Ewald Geschwinde 11:43
Re: Object description at Client Window Kumar 12:09
Re: Object description at Client Window Kumar 12:37
Re: [postgres] IPv6-Datentyp(en) in PostgreSQL? 📎 stephan.rupp 13:46
Re: [postgres] IPv6-Datentyp(en) in PostgreSQL? Ewald Geschwinde 14:12
Re: Object description at Client Window achill 14:33
Re: Object description at Client Window George Weaver 14:49
new max function Rodrigo Gesswein 18:13
Re: new max function Mike Rylander 21:32

Oct. 18, 2003

Thread Author Time
Re: new max function Tom Lane 02:51
Re: Postgres with OpenSSL Roberto Mello 18:52
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen Ian Barwick 21:54

Oct. 19, 2003

Thread Author Time
date_trunc for 5 minutes intervals email lists 13:38
problem with sql Adaś 16:56
Re: date_trunc for 5 minutes intervals Mathieu Arnold 21:00

Oct. 20, 2003

Thread Author Time
Which is faster SQL or PL/PGSQL George A.J 02:57
Re: Which is faster SQL or PL/PGSQL Christopher Browne 03:48
Re: Which is faster SQL or PL/PGSQL Josh Berkus 05:29
Max input parameter for a function Kumar 06:28
Re: date_trunc for 5 minutes intervals Richard Huxton 08:27
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen Alvar Freude 09:43
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen Alvar Freude 09:46
query or design question Adam Witney 10:58
Re: Max input parameter for a function Christopher Browne 12:29
Question regarding triggers Dmitri Fuerle 13:00
Unable to user pg_restore Kumar 13:01
Re: date_trunc for 5 minutes intervals email lists 13:04
Scripting only the functions Kumar 13:04
Re: Question regarding triggers achill 13:22
Re: Question regarding triggers A.Bhuvaneswaran 13:31
Re: Question regarding triggers Tom Lane 13:48
Re: Question regarding triggers achill 13:56
Re: Question regarding triggers Dmitri Fuerle 15:07
Re: Which is faster SQL or PL/PGSQL Michael Pohl 15:36
Re: Unable to user pg_restore Tom Lane 16:49
Re: Which is faster SQL or PL/PGSQL Richard Huxton 17:09
Re: query or design question Richard Huxton 17:12
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen weigelt 17:18
Re: Scripting only the functions Josh Berkus 17:21
Re: Scripting only the functions Richard Huxton 17:23
Re: Which is faster SQL or PL/PGSQL Joe Conway 17:24
Re: Which is faster SQL or PL/PGSQL Richard Huxton 17:49
[postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org Peter Eisentraut 17:53
Re: [postgres] Deutsche PostgreSQL-Mailingliste unter Alvar Freude 17:57
Re: Which is faster SQL or PL/PGSQL Joe Conway 18:11
Re: Which is faster SQL or PL/PGSQL Josh Berkus 18:24
Crosstab question Adam Witney 18:40
Re: Which is faster SQL or PL/PGSQL Joe Conway 18:54
Re: Which is faster SQL or PL/PGSQL Josh Berkus 19:00
Re: [postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org weigelt 19:05
Re: Which is faster SQL or PL/PGSQL Tom Lane 19:50
Re: Crosstab question Joe Conway 19:51
Re: [postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org Ewald Geschwinde 19:52
Re: Which is faster SQL or PL/PGSQL Josh Berkus 20:58
converting an oracle procedure to postgres Clint Stotesbery 21:20
Re: converting an oracle procedure to postgres Josh Berkus 21:28
Re: converting an oracle procedure to postgres Tom Lane 22:32

Oct. 21, 2003

Thread Author Time
assorted Postgres SQL/ORDBMS questions Clint Stotesbery 01:40
Re: assorted Postgres SQL/ORDBMS questions Josh Berkus 02:47
Re: assorted Postgres SQL/ORDBMS questions Tom Lane 03:59
Re: Alias-Error Jost Richstein 07:17
Writing the SQL queries inside Functions and operators Dharan 07:34
Many joins: monthly summaries S-L--O--W Michael Glaesmann 12:09
function problem geraldo 12:25
how to create a multi columns return function ? jclaudio 13:08
plpgsql related question: intervals and variables Wilhelm Graiss 13:58
Re: Fw: Max input parameter for a function Josh Berkus 16:33

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