pgsql-sql - July 2002

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

July 1, 2002

Thread Author Time
Re: graphical interface - admin Andreas Joseph Krogh 09:10
Re: graphical interface - admin Oleg Bartunov 11:29
Re: graphical interface - admin Andreas Joseph Krogh 12:16
Re: graphical interface - admin Oleg Bartunov 13:00
Re: graphical interface - admin Andreas Joseph Krogh 13:06
Re: graphical interface - admin Roberto Mello 14:37
Re: pl/pgsql capabilities? Roberto Mello 14:40
unsubscribe Simeone, Mario 16:28
Using union to avoid creating temp table Bruno Wolff III 16:31
Re: Using union to avoid creating temp table Tom Lane 17:17
Re: pg_restore cannot restore function Jan Wieck 18:13
CASE Select, referring to selected value Nick Riemondi 22:00
Re: pl/pgsql capabilities? Ferenc Engard 23:37

July 2, 2002

Thread Author Time
Re: pl/pgsql capabilities? Roberto Mello 05:23
Fw: Postgres function call problems Sandeep Chibber 10:40
Re: CASE Select, referring to selected value Achilleus Mantzios 12:16
Temporary table instead of repeated joins Chantal Ackermann 12:48
Re: CASE Select, referring to selected value Christopher Kings-Lynne 13:57
Re: CASE Select, referring to selected value Nick Riemondi 14:30
Why doesn't it use indexes? Ahti Legonkov 15:46
constraint Ricardo Javier Aranibar León 20:07
Selecting data from a table created in another database... Ligia Pimentel 20:13
Re: pg_restore cannot restore function Jie Liang 23:08

July 3, 2002

Thread Author Time
Re: constraint Christopher Kings-Lynne 07:02
Re: Why doesn't it use indexes? Christopher Kings-Lynne 07:42
Re: pg_restore cannot restore function Achilleus Mantzios 07:51
Re: Why doesn't it use indexes? Achilleus Mantzios 07:54
How do I access the current row from a trigger? Magnus Sjöstrand 08:28
Localization GRIMOIS Eric 14:48
Re: pg_restore cannot restore function Jie Liang 15:25
Re: Localization Bruce Momjian 16:28
Can this be done with sql? teknokrat 18:32
Re: pg_restore cannot restore function Jie Liang 19:03
Re: Selecting data from a table created in another database... Bruce Momjian 20:22
Possible Bug regarding temp tables (sql or psql?) 📎 Mark Frazer 20:59
Re: Possible Bug regarding temp tables (sql or psql?) Mark Frazer 21:12
bit field changes in 7.2.1 Kevin Brannen 22:16
postgres7.2.1 upgrading Jie Liang 22:45
Re: How do I access the current row from a trigger? Stephan Szabo 23:43

July 4, 2002

Thread Author Time
Re: Possible Bug regarding temp tables (sql or psql?) Christopher Kings-Lynne 01:38
Re: Selecting data from a table created in another database... Rudi Starcevic 01:47
Re: postgres7.2.1 upgrading Christopher Kings-Lynne 02:55
Re: [SQL] pg_restore cannot restore function 📎 Bruce Momjian 03:03
Re: [SQL] pg_restore cannot restore function Tom Lane 05:33
Re: [SQL] pg_restore cannot restore function Bruce Momjian 05:36
how to write procedures srikanth 10:45
Re: [SQL] Possible Bug regarding temp tables (sql or psql?) Mark Frazer 11:23
Re: [SQL] Possible Bug regarding temp tables (sql or psql?) Bruce Momjian 12:26
Re: how to write procedures Achilleus Mantzios 13:17
Re: Selecting data from a table created in another database... Ligia Pimentel 13:49
Re: how to write procedures Rajesh Kumar Mallah. 14:12
Re: Can this be done with sql? Rajesh Kumar Mallah. 14:50
Re: how to write procedures Achilleus Mantzios 15:56
Boolean to int Stephane Schildknecht 17:26
Re: Boolean to int Stephan Szabo 18:45
Re: Can this be done with sql? teknokrat 21:05
Re: Boolean to int Arjen van der Meijden 21:32

July 5, 2002

Thread Author Time
Re: Possible Bug regarding temp tables (sql or psql?) Christopher Kings-Lynne 02:02
Re: Possible Bug regarding temp tables (sql or psql?) Bruce Momjian 02:09
Re: Possible Bug regarding temp tables (sql or psql?) Tom Lane 02:32
Re: Possible Bug regarding temp tables (sql or psql?) Bruce Momjian 02:39
How do i return a dataset from a stored procedure teknokrat 08:32
sql statement how to do ? juerg.rietmann 09:02
algoritme stephane 09:41
Is Dropping a column "CHECK" constraint possible? Rajesh Kumar Mallah. 11:59
how to use nextval() juerg.rietmann 12:03
Re: Selecting data from a table created in another database... Chantal Ackermann 12:08
Re: how to use nextval() Stephane Schildknecht 12:28
Re: how to use nextval() Achilleus Mantzios 12:37
Re: sql statement how to do ? Manfred Koizar 12:40
Re: Possible Bug regarding temp tables (sql or psql?) Mark Frazer 13:38
Re: Boolean to int Stephane Schildknecht 13:38
Re: Boolean to int Arjen van der Meijden|Moderator P&W / Serverbeheer 15:12
Re: How do i return a dataset from a stored procedure Stephan Szabo 16:10
Re: How do i return a dataset from a stored procedure Roberto Mello 16:21
i18n in pgSQL Vernon Wu 18:29
Re: Possible Bug regarding temp tables (sql or psql?) Bruce Momjian 18:52

July 6, 2002

Thread Author Time
Re: How do i return a dataset from a stored procedure Bruce Momjian 02:17
Re: Is Dropping a column "CHECK" constraint possible? Christopher Kings-Lynne 04:35
Re: Is Dropping a column "CHECK" constraint possible? Rajesh Kumar Mallah. 05:03
Problem on PostgreSQL (error code, store procedures) Carmen Wai 06:45

July 7, 2002

Thread Author Time
Re: bit field changes in 7.2.1 Peter Eisentraut 10:59
Re: Localization Peter Eisentraut 10:59
Re: Can this be done with sql? Rajesh Kumar Mallah. 13:36
Re: Is Dropping a column "CHECK" constraint possible? Rajesh Kumar Mallah. 13:45
manipulating the database in plsql teknokrat 18:40
Bad SUM result Roy Souther 20:25
Re: Bad SUM result Stephan Szabo 20:44
newbie question Mirco D'Angelo 21:59

July 8, 2002

Thread Author Time
INSERT only under certain conditions (SELECT) Joachim Trinkwitz 01:18
[No subject] jack 08:11
Re: INSERT only under certain conditions (SELECT) Rajesh Kumar Mallah. 08:12
Double quotes? Archibald Zimonyi 10:35
Re: Double quotes? Archibald Zimonyi 10:58
Re: INSERT only under certain conditions (SELECT) Bruno Wolff III 12:40
Re: Double quotes? Christoph Haller 12:54
Variables in PSQL Roger Mathis 13:24
is there a way to get hh:mm:ss given seconds Narendra A 14:28
Re: bit field changes in 7.2.1 Kevin Brannen 15:10
Re: Bad SUM result Jean-Luc Lachance 15:22
Re: INSERT only under certain conditions (SELECT) Joachim Trinkwitz 15:49
Re: manipulating the database in plsql Roberto Mello 15:51
Re: newbie question Roberto Mello 15:53
Re: manipulating the database in plsql Janning Vygen 16:36
Re: newbie question Richard Huxton 16:49
Rule WHERE condition problem Kristian Eide 17:45
Re: Bruce Momjian 18:40
Re: newbie question Ignacio Coloma 20:28
PLPGSQL language documentation Sandy Ear 22:45

July 9, 2002

Thread Author Time
Re: how to write procedures Bhuvan A 04:40
Re: newbie question Christopher Kings-Lynne 06:39
Re: newbie question Achilleus Mantzios 06:45
Waiting for Update JGM 07:04
SQL problem with aggregate functions. David BOURIAUD 08:36
Re: INSERT only under certain conditions (SELECT) Bruno Wolff III 12:18
Re: Rule WHERE condition problem Jan Wieck 13:00
Re: Rule WHERE condition problem Tom Lane 13:23
Re: Rule WHERE condition problem Kristian Eide 13:41
Re: export plpgsql function to file Achilleus Mantzios 14:30
Re: is there a way to get hh:mm:ss given seconds Tod McQuillin 14:41
Re: is there a way to get hh:mm:ss given seconds David Stanaway 14:58
Re: PLPGSQL language documentation Bradley Kieser 17:10
Re: PLPGSQL language documentation Josh Berkus 17:11
export plpgsql function to file Joseph Syjuco 18:06
Re: PLPGSQL language documentation Jeff Eckermann 19:02
Re: is there a way to get hh:mm:ss given seconds Kevin Brannen 19:11
pg_restore cannot restore index Jie Liang 19:44
Re: pg_restore cannot restore index Jie Liang 21:00

July 10, 2002

Thread Author Time
Re: pg_restore cannot restore index 📎 Bruce Momjian 02:58
Re: is there a way to get hh:mm:ss given seconds Josh Berkus 05:46
Re: is there a way to get hh:mm:ss given seconds Christopher Kings-Lynne 05:49
Re: Bad SUM result Petr Jezek 08:00
query/transaction history/logs q 08:34
Re: query/transaction history/logs David BOURIAUD 09:08
Help with function optimisation Ian Cass 09:38
Error with DISTINCT and AS keywords Andreas Schlegel 11:57
How to get total number of rows when using LIMIT/OFFSET? Dirk Lutzebaeck 12:25
Re: Error with DISTINCT and AS keywords Achilleus Mantzios 12:25
Re: Problem on PostgreSQL (error code, store procedures) Christoph Haller 12:47
Re: Variables in PSQL Christoph Haller 13:00
Re: Error with DISTINCT and AS keywords Richard Huxton 13:31
Re: Help with function optimisation Tom Lane 13:34
Re: Error with DISTINCT and AS keywords Tom Lane 14:09
Re: Error with DISTINCT and AS keywords Jean-Luc Lachance 15:22
Re: Waiting for Update Jan Wieck 15:27
Re: pg_restore cannot restore index Jie Liang 15:42
XML to Postgres conversion Nathan Hill 16:24
BETWEEN bug? Josh Berkus 19:35
Insert Function David Durst 19:59
Re: BETWEEN bug? Stephan Szabo 20:10
Re: Insert Function Ian Barwick 20:45
Re: BETWEEN bug? Josh Berkus 21:57

July 11, 2002

Thread Author Time
Returning rows from functions David Durst 00:37
Re: How to get total number of rows when using LIMIT/OFFSET? Bruce Momjian 01:50
Re: pg_restore cannot restore index Bruce Momjian 02:05
Re: BETWEEN bug? Josh Berkus 03:22
Re: Returning rows from functions Joe Conway 04:59
Re: Insert Function Ian Barwick 06:38
Re: SQL problem with aggregate functions. Christoph Haller 10:37
list of tables ? Steve Brett 14:00
Re: list of tables ? -update to question ... Steve Brett 14:07
Re: list of tables ? Ian Barwick 14:09
Re: list of tables ? Achilleus Mantzios 14:09
Re: list of tables ? Steve Brett 14:13
Re: XML to Postgres conversion George.T.Essig 14:23
how to inherits the references... frederik nietzsche 14:43
Re: [SQL] XML to Postgres conversion Rudi Starcevic 15:18
please help on query Luis Alberto Amigo Navarro 15:22
Re: pg_restore cannot restore index Jie Liang 15:41
Re: how to inherits the references... Stephan Szabo 16:00
Re: [HACKERS] please help on query Manfred Koizar 16:47
Re: [HACKERS] please help on query Luis Alberto Amigo Navarro 17:40
Re: please help on query J. R. Nield 18:06
Re: please help on query Andy Kopciuch 18:09
Re: list of tables ? -update to question ... Jan Wieck 18:38
Re: [HACKERS] please help on query Manfred Koizar 18:44
Re: pg_restore cannot restore index Jie Liang 19:48
Re: please help on query Hannu Krosing 20:48
Re: please help on query Hannu Krosing 20:51
Re: please help on query Hannu Krosing 21:08
Re: SQL problem with aggregate functions. Loyd Goodbar 22:08
Please, HELP! Why is the query plan so wrong??? Dmitry Tkach 22:50
Re: [SQL] Please, HELP! Why is the query plan so wrong??? Jie Liang 23:26
PostgreSQL - contrib/xml Rudi Starcevic 23:27

July 12, 2002

Thread Author Time
Re: PostgreSQL - contrib/xml Christopher Kings-Lynne 01:39
Query kill Rudi Starcevic 05:00
Re: Query kill Bruce Momjian 05:01
rules / triggers on insert. why after? Ahti Legonkov 09:24
Re: how to inherits the references... frederik nietzsche 10:29
Re: [HACKERS] please help on query Luis Alberto Amigo Navarro 11:37
Re: [HACKERS] please help on query Jakub Ouhrabka 11:50
Re: [HACKERS] please help on query Jakub Ouhrabka 11:52
Re: rules / triggers on insert. why after? Jan Wieck 13:41
Re: how to inherits the references... Stephan Szabo 14:03
Re: list of tables ? Christoph Haller 14:16
Re: SQL problem with aggregate functions. Jean-Luc Lachance 14:28
Re: [SQL] Please, HELP! Why is the query plan so wrong??? Dmitry Tkach 14:34
Re: rules / triggers on insert. why after? Tom Lane 15:07
Re: [SQL] Please, HELP! Why is the query plan so wrong??? Jie Liang 15:29
config postgresql.conf?? Jie Liang 15:32

Browse Archives

Prev | Next