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

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
Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {} Markus Bertheau 06:08
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Achilleus Mantzios 06:21
Re: datatype conversion on postgresql 7.4.1 Richard Huxton 07:45
Re: could not devise a query plan Szűcs Gábor 10:39
Re: Transaction in plpgslq Rafa Couto 10:40
Re: Transaction in plpgslq Jan B. 11:00
Re: [SQL] could not devise a query plan Szűcs Gábor 11:55
Re: Transaction in plpgslq Richard Huxton 11:59
Новое предложение для Российских туристических агентств – Северный Кипр Retro-tyr-yandex 13:01
AWARD NOTIFICATION FINAL NOTICE: Angel C.Santiago. 15:07
INVESTMENT peter nkosi 15:12
yaza rahat girin kiloverin saðlýklý yaþayýn kiloverin.com 15:36
Re: Transaction in plpgslq Andrew Hammond 16:10
DROP IF ... CG 17:44
Re: [SQL] could not devise a query plan Tom Lane 18:12
Re: Help: Function for splitting VARCHAR column and migrating its data to 2 new tables Tony Wasson 18:15
Tip ? Alain 18:26
Re: Tip ? Scott Marlowe 18:34
Geschäftliches Angebot J.Bougani 20:25
Duplicated records lucas 20:59
Re: Duplicated records PFC 21:26
Re: DROP IF ... Thomas F. O'Connell 22:07

May 25, 2005

Thread Author Time
Spam Shocking document 📎 info 01:35
Финансовый анализ. О классическом и стратегическом подходе. Финансовая аналитика 01:39
Правовые аспекты коммерческой деятельности ПНП 02:02
Re: [despammed] Duplicated records Andreas Kretschmer 05:03
(Mis)using the PostgreSQL planner to get estimated row counts Nick Johnson 07:13
(Mis)using the PostgreSQL planner to get estimated row counts Nick Johnson 07:13
[Fr*e-Content] Embrace the Four Fundamental Laws of Communication Mark Susnow, Life Coach 07:48
Delivery reports about your e-mail 📎 The Post Office 09:48
Permissions + Views + Functions = relation not exist when not owner Adie 12:55
Бульдозеры, Экскаваторы, Буровые, Металлопрокат. UralNefteGaz 13:08
e-mail рассылки e-mail rassylka 13:39
Re: Permissions + Views + Functions = relation not exist when not owner Tom Lane 13:58
Sql select like question. hatuan 15:28
Обучение: Взыскание убытков и защита от взыскания. 📎 .. 15:45
Re: Duplicated records lucas 16:58
Re: Duplicated records Alvaro Herrera 17:44
Re: [despammed] Re: Duplicated records Andreas Kretschmer 17:57
Re: Duplicated records lucas 20:53
Re: Sql select like question. Tom Lane 21:19
gua Mineral - Descartveis - vre 📎 jir- Aguas Nascente - oxg 22:54
Industry News Trinidad 23:50

May 26, 2005

Thread Author Time
Spam Congratulations! 📎 noreply 02:02
Руководителю компании Ассоциация Бизнес Мастерства 05:34
Re: Sql select like question. hatuan 11:50
unsubscribe U K Laxmi 12:52
Faster downloads Blaine Hancock 13:55
Re: Sql select like question. Tom Lane 14:51
Re: Sql select like question. hatuan 15:49

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