pgsql-sql since 2005-05-08 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

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
Re: Duplicated records Andrew Hammond 16:33
[Fwd: unsubscribe] noor 18:21
Re: ARRAY() returning NULL instead of ARRAY[] resp. {} 📎 Joe Conway 19:06
БЮДЖЕТИРОВАНИЕ, НАЛОГОВОЕ ПЛАНИРОВАНИЕ И ОПТИМИЗАЦИЯ НАЛОГООБЛОЖЕНИЯ, АВТОТРАНСПОРТ И АВТОМОБИЛЬНЫЕ УСЛУГИ kharkov.ua fpltgqgkre 19:14
L@VDVDIwV[YxDVDI ¥9800ねっと 19:50
OurPlanet... environmental newsletter E - The Environmental Magazine 23:08

May 27, 2005

Thread Author Time
Spam Mail Delivery (failure) 📎 zsh-workers-subscribe 02:36
3 tables, slow count(*), order by Seq Scan in Query Plan ogjunk-pgjedan 03:56
Assistance Mariam Abacha 11:31
Re: 3 tables, slow count(*), order by Seq Scan in Query Plan Tony Wasson 15:18
SQL command Error: "create table ... Like parentTable including defaults" Ying Lu 15:48
Re: SQL command Error: "create table ... Like parentTable Bricklen Anderson 16:02
Re: SQL command Error: "create table ... Like parentTable including defaults" Michael Fuhr 16:17
Privileged Position Ben Hane 17:51

May 28, 2005

Thread Author Time
This may help fight HIV viruses Menage Troix 12:21
SUSPENDED ACCOUNT 📎 admin 13:52

May 30, 2005

Thread Author Time
Re: [4] Jay Sheehan 03:23
Generic Join on Arrays KÖPFERL Robert 13:42
Re: Generic Join on Arrays Michael Fuhr 14:08
Re: Generic Join on Arrays KÖPFERL Robert 14:14
Impossible with pl/pgsql? Markus Bertheau ☭ 15:15
WINNING NOTIFICATION IBM COMPUTER EMAIL LOTTERY INTERNATIONAL PROMOTIONS 15:52
Re: Impossible with pl/pgsql? Michael Fuhr 16:13
Re: Impossible with pl/pgsql? Tom Lane 16:21
Report to Sender Caad_Notes1 19:03
[Fr*e-Content] "Need Help? You Might Want to Consider Outsourcing" MerlesWorld 21:04
Your Microcap Communiqu Antoinette 21:35

May 31, 2005

Thread Author Time
качественная полиграфия для ВАС Egbert Aarons 01:04
Re: Impossible with pl/pgsql? Ramakrishnan Muralidharan 04:40

Browse Archives

Prev | Next