pgsql-sql - May 2005

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 12 13 15 16 17 18 19 20 22 23 24 25 26 27 28 30 31

May 1, 2005

Thread Author Time
Re: can someone jelp me on this? Ragnar Hafstað 09:15
Re: How to connect ORACLE database from Postgres functionusing plpgsql/pltclu? Dinesh Pandey 11:27
Discordance between the way select is called. Patrice Drolet 20:21

May 2, 2005

Thread Author Time
Re: pgtop, display PostgreSQL processes in `top' style Tom Lane 03:04
Re: trigger/rule question Enrico Weigelt 03:31
Re: trigger/rule question Enrico Weigelt 03:41
Array of Arrays of int Leo Fink 03:50
Re: pgtop, display PostgreSQL processes in `top' style Enrico Weigelt 03:55
Re: Array of Arrays of int Tom Lane 04:11
Re: Division in Postgre hatuan 04:15
Re: Array of Arrays of int Leo Fink 04:26
Re: trigger/rule question Ramakrishnan Muralidharan 04:49
Re: can someone jelp me on this? Ramakrishnan Muralidharan 05:00
how many tuples on a cursor? Andreas Kretschmer 07:13
Re: trigger/rule question Christoph Haller 07:58
Re: PHP postgres connections Mauro Bertoli 09:10
Re: how many tuples on a cursor? Christoph Haller 11:17
Re: how many tuples on a cursor? Tom Lane 15:04
Re: how many tuples on a cursor? Christoph Haller 15:20
Query two database at once Stéphane RIFF 15:36
Java and Currval Sam Adams 16:30
Re: Java and Currval Michael Fuhr 16:46
Re: Java and Currval Volkan YAZICI 16:49
Re: Java and Currval Bruno Wolff III 17:41
odd error Joel Fradkin 17:49
Re: [despammed] Query two database at once Andreas Kretschmer 17:51
Record Log Trigger lucas 19:10
Re: Record Log Trigger CHRIS HOOVER 19:27
Function or Field? lucas 20:16
Re: Function or Field? Joel Fradkin 21:10
Re: [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style Markus Schaber 22:09
Re: [Dbdpg-general] [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style David Wheeler 23:23

May 3, 2005

Thread Author Time
Trimming the cost of ORDER BY in a simple query ogjunk-pgjedan 04:35
Re: Trimming the cost of ORDER BY in a simple query Mischa Sandberg 06:31
Re: Trimming the cost of ORDER BY in a simple query Ragnar Hafstað 07:22
Re: Trimming the cost of ORDER BY in a simple query Ezequiel Tolnay 08:08
Re: Trimming the cost of ORDER BY in a simple query Harald Fuchs 10:59
Re: Function or Field? Ramakrishnan Muralidharan 11:49
Re: Function or Field? lucas 11:58
Re: Record Log Trigger lucas 12:14
Re: Function or Field? Tambet Matiisen 12:32
Re: Function or Field? Frank Bax 13:41

May 4, 2005

Thread Author Time
Re: Record Log Trigger Ramakrishnan Muralidharan 04:44
CASCADE and TRIGGER - Some weird problem Sonic 07:31
Mutex via database Enrico Weigelt 11:28
Re: Mutex via database Markus Schaber 11:38
all server processes terminated; reinitializing 2000 Informatica 14:08
Re: all server processes terminated; reinitializing Markus Schaber 14:19
Re: [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style Jeff - 14:28
HELP: aggregating insert rule for multirow inserts. Mischa Sandberg 19:27

May 5, 2005

Thread Author Time
accessing multiple database mohammad izwan ibrahim 02:47
Re: Calling a stored procedure from another stored procedure... Ezequiel Tolnay 03:55
Re: [despammed] accessing multiple database Andreas Kretschmer 06:50
Re: accessing multiple database Richard Huxton 06:56
Re: HELP: aggregating insert rule for multirow inserts. Mikey 07:39
Re: accessing multiple database mohammad izwan ibrahim 09:09
Re: accessing multiple database Richard Huxton 09:21
Select of a function that returns a array Listas Evandro (Não use este endereço para mensagens pessoais) 14:27
Select of a function that returns a array Listas Evandro (Não use este endereço para mensagens pessoais) 14:38
Re: HELP: aggregating insert rule for multirow inserts. a3a18850 17:58
Re: multi-column unique constraints with nullable columns Mikey 19:03
Re: multi-column unique constraints with nullable columns Tornroth, Phill 19:06

May 6, 2005

Thread Author Time
Re: Select of a function that returns a array Ramakrishnan Muralidharan 04:46
select within aggregate? Vortex 07:25
Re: select within aggregate? Ramakrishnan Muralidharan 08:04
Re: select within aggregate? Vortex 08:40
pg_dump without data Kenneth Gonsalves 09:14
Re: select within aggregate? Bruno Wolff III 12:49
encoding Joel Fradkin 13:50
Re: pg_dump without data Philip Hallstrom 17:56
Re: pg_dump without data Scott Marlowe 17:59
ORDER BY Optimization Derek Buttineau|Compu-SOLVE 19:48
Re: [SQL] ORDER BY Optimization Rosser Schwarz 20:35
Re: [SQL] ORDER BY Optimization Derek Buttineau|Compu-SOLVE 20:54

May 7, 2005

Thread Author Time
Re: select within aggregate? Vortex 16:12
Re: encoding Aarni Ruuhimäki 16:32
Re: Discordance between the way select is called. Stephan Szabo 16:51
Re: encoding Peter Eisentraut 20:54
Re: [SQL] ORDER BY Optimization Tom Lane 22:55

May 8, 2005

Thread Author Time
Re: encoding Aarni Ruuhimäki 11:59
Re: encoding Tom Lane 16:43
Doing range-predicates right (correction) Mischa Sandberg 16:50
Re: encoding Aarni Ruuhimäki 17:20
interesting SQL puzzle - concatenating column with itself. Nick Fankhauser 18:55
Re: interesting SQL puzzle - concatenating column with itself. Alvaro Herrera 21:29
Re: interesting SQL puzzle - concatenating column with itself. Nick Fankhauser 21:48

May 9, 2005

Thread Author Time
Re: diff value retuns, debug mode and play mode AL ELK 14:05
default value for select? 📎 Mark Fenbers 16:57
Re: default value for select? Philip Hallstrom 17:18
Re: default value for select? Keith Worthington 17:26
Re: default value for select? Tony Wasson 17:30
Re: ORDER BY Optimization 📎 Derek Buttineau|Compu-SOLVE 18:10

May 10, 2005

Thread Author Time
Re: CASCADE and TRIGGER - Some weird problem Ramakrishnan Muralidharan 04:32
unsuscribe joffer 10:43
Re: interesting SQL puzzle - concatenating column with itself. Nick Fankhauser 19:56
Re: interesting SQL puzzle - concatenating column with itself. PFC 20:45
Re: interesting SQL puzzle - concatenating column with itself. Dmitri Bichko 21:53

May 12, 2005

Thread Author Time
Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? Dennis.Jiang 19:07
md5 in pg_shadow? subhash 21:01
Re: md5 in pg_shadow? Michael Fuhr 22:40

May 13, 2005

Thread Author Time
Re: interesting SQL puzzle - concatenating column with itself. Greg Stark 06:05
Replacing a table with constraints 📎 Mark Fenbers 18:38
Re: Replacing a table with constraints Ing. Jhon Carrillo 18:49
Re: Replacing a table with constraints 📎 Mark Fenbers 19:55
Re: Replacing a table with constraints Scott Marlowe 20:03
Re: Replacing a table with constraints Ragnar Hafstað 22:43

May 15, 2005

Thread Author Time
Significance of Database Encoding Rajesh Mallah 15:33
Re: Significance of Database Encoding [ update ] Rajesh Mallah 16:16
Re: Significance of Database Encoding PFC 17:02
Re: Significance of Database Encoding Rajesh Mallah 18:38
Re: Significance of Database Encoding PFC 19:48

May 16, 2005

Thread Author Time
Re: Significance of Database Encoding Rajesh Mallah 02:16
choosing index to use Ilya A. Kovalenko 11:39
Re: choosing index to use PFC 18:26
ORDER BY handling mixed integer and varchar values David B 18:47
Re: ORDER BY handling mixed integer and varchar values PFC 19:12
Re: ORDER BY handling mixed integer and varchar values Edmund Bacon 19:18
Re: ORDER BY handling mixed integer and varchar values Rod Taylor 19:19
Re: ORDER BY handling mixed integer and varchar values Ragnar Hafstað 19:32
sub-selects 📎 Mark Fenbers 19:45
Re: sub-selects PFC 20:36
getting duplicate number is there a Joel Fradkin 21:36

May 17, 2005

Thread Author Time
Re: getting duplicate number is there a Ezequiel Tolnay 05:02
Re: getting duplicate number is there a Richard Huxton 07:11
plpython setof Sim Zacks 12:16
Re: getting duplicate number is there a Joel Fradkin 12:31
Re: getting duplicate number is there a Bruno Wolff III 13:18
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Scott Marlowe 17:01
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? Bruno Wolff III 17:06
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? Andrew Sullivan 17:06
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Alain 17:48
Re: interesting SQL puzzle - concatenating column with itself. PFC 17:57
triggering an external action Jay Parker 18:01
Re: triggering an external action Bricklen Anderson 18:07
Re: triggering an external action Magnus Hagander 18:09
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Ragnar Hafstað 18:12
ERROR: unterminated quoted string... help Postgres Admin 18:15
Re: triggering an external action Jay Parker 18:20
Re: ERROR: unterminated quoted string... help Scott Marlowe 18:27
Re: [SQL] ERROR: unterminated quoted string... help Postgres Admin 18:33
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Alain 18:43
Re: ERROR: unterminated quoted string... help Mariusz Pękala 19:17
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Andrew Sullivan 20:11
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Ragnar Hafstað 22:03
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as PFC 22:13
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Ragnar Hafstað 22:27

May 18, 2005

Thread Author Time
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Alain 02:16
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Ragnar Hafstað 08:28
Re: ERROR: unterminated quoted string... help Volkan YAZICI 08:35
Changed to: how to solve the get next 100 records problem Alain 15:42
Meaning of ERROR: tuple concurrently updated KÖPFERL Robert 15:50
Re: Meaning of ERROR: tuple concurrently updated Tom Lane 16:00
Turning column into *sorted* array? Felix E. Klee 16:12
Help with views/rules... Peter Bense 17:40
Re: Changed to: how to solve the get next 100 records problem PFC 17:52
Re: Changed to: how to solve the get next 100 records problem Ragnar Hafstað 17:53
Re: Turning column into *sorted* array? PFC 17:54
Re: Turning column into *sorted* array? Felix E. Klee 18:17
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Chris Browne 19:52
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Sean Davis 20:20

May 19, 2005

Thread Author Time
postgre variable bandeng 02:11
Re: postgre variable Richard Huxton 06:55
Re: postgre variable Volkan YAZICI 07:42
Re: Meaning of ERROR: tuple concurrently updated KÖPFERL Robert 07:53
Re: postgre variable KÖPFERL Robert 09:11
Aggregate Functions Template 📎 Mark Fenbers 19:17
Re: Aggregate Functions Template Michael Fuhr 20:56

May 20, 2005

Thread Author Time
Re: Aggregate Functions Template 📎 Mark Fenbers 10:25
Transaction in plpgslq Rafa Couto 10:47
How do I quit in the middle of a SQL script? Wei Weng 17:22
Re: Transaction in plpgslq Andrew Hammond 17:54
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Keith Worthington 18:27
Re: How do I quit in the middle of a SQL script? John DeSoi 18:36
Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Scott Marlowe 18:42
DBD::Pg on Enterprise 3 📎 Mark Fenbers 19:46
Re: DBD::Pg on Enterprise 3 Tom Lane 20:35
Re: How do I quit in the middle of a SQL script? Mischa Sandberg 20:51

May 22, 2005

Thread Author Time
Balance Calculation Muhyiddin A.M Hayat 04:15
Re: [despammed] Balance Calculation Andreas Kretschmer 08:17
Re: [despammed] Balance Calculation Andreas Kretschmer 08:42
Re: [despammed] Balance Calculation LAMBEAU Bernard 09:03
Calling Functions in RULEs Jan B. 09:24
datatype conversion on postgresql 7.4.1 Timo Roessner 11:29

May 23, 2005

Thread Author Time
Need clarification palanivel.kumaran 09:52
Re: Calling Functions in RULEs KÖPFERL Robert 10:01
Re: Need clarification Achilleus Mantzios 10:17
need date clarification palanivel.kumaran 10:56
Re: Need clarification palanivel.kumaran 11:01
Re: Need clarification KÖPFERL Robert 11:04
Re: [despammed] need date clarification Andreas Kretschmer 11:26
Re: [despammed] Re: Need clarification Andreas Kretschmer 11:41
ARRAY() returning NULL instead of ARRAY[] resp. {} Markus Bertheau 18:33
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Jan B. 18:54
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Markus Bertheau 18:58
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Joe Conway 20:04

May 24, 2005

Thread Author Time
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Tom Lane 04:06
Вторая жизнь мягкой мебели. Carlo Annunziata 04:31
Help: Function for splitting VARCHAR column and migrating its data to 2 new tables ogjunk-pgjedan 04:42
Spam I cannot forget you! 📎 coopercc 05:58
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Markus Bertheau 06:02

Browse Archives

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