Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-sql - July 2002

2002-07-01

• 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)

2002-07-02

• 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)

2002-07-03

• 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)

2002-07-04

• 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)

2002-07-05

• 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)

2002-07-06

• 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)

2002-07-07

• 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)

2002-07-08

• 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)

2002-07-09

• 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)

2002-07-10

• 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)

2002-07-11

• 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)

2002-07-12

• 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)