pgsql-sql - March 2009

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

March 3, 2009

Thread	Author	Time
"union" vs. left join	Emi Lu	20:26
Re: "union" vs. left join	ries van Twisk	20:33

March 5, 2009

Thread	Author	Time
[No subject]	Jhonny Velasquez c.	15:48
uso de dblink en php	Jhonny Velasquez c.	15:50
Writing a generic delete rule for a view	Scott Cain	18:20
Re: uso de dblink en php	Oliveiros Cristina	18:25
Re:	Ivan Sergio Borgonovo	19:02
Re: uso de dblink en php	Andy Anderson	19:20

March 7, 2009

Thread	Author	Time
Re:	Andreas Wenk	17:42

March 9, 2009

Thread	Author	Time
Inherits is not encouraged?	Emi Lu	20:18
Re: Inherits is not encouraged?	Tom Lane	23:55

March 10, 2009

Thread	Author	Time
Re: Inherits is not encouraged?	Karsten Hilbert	08:23

March 11, 2009

Thread	Author	Time
Problem with an Empty Column	hidura	05:41
Re: Problem with an Empty Column	Scott Marlowe	06:17
Convert text from UTF8 to ASCII	Paul Dam	15:04
Re: Convert text from UTF8 to ASCII	Claus Guttesen	15:43
Re: Convert text from UTF8 to ASCII	Leif B. Kristensen	15:46
Re: Convert text from UTF8 to ASCII	Paul Dam	15:51
Re:	F. Jovan Jester	18:33

March 12, 2009

Thread	Author	Time
Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field	Allan Kamau	12:53
Permanent alias for postgresql table	Marco Lechner	12:59
Re: Permanent alias for postgresql table	Thomas Kellerer	13:55
Re: Permanent alias for postgresql table	Marco Lechner	14:26
Re: Permanent alias for postgresql table	Joshua Tolley	14:30
Re: Permanent alias for postgresql table	Thomas Kellerer	14:39
select count of all overlapping geometries and return 0 if none.	Duffer Do	17:28
Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field	Allan Kamau	18:10
Re: Permanent alias for postgresql table	Lennin Caro	18:54

March 13, 2009

Thread	Author	Time
subquery question	Sebastian Böhm	03:06
Re: subquery question	Bob Henkel	04:31
Re: Convert text from UTF8 to ASCII	Paul Dam	08:38
xpath_table feature	Marcin Stępnicki	11:34
RE : [SQL] Convert text from UTF8 to ASCII	seb JACK	12:49
Re: select count of all overlapping geometries and return 0 if none.	Steve Midgley	17:32
Re: Permanent alias for postgresql table	Mina R Waheeb	18:38
Re: select count of all overlapping geometries and return 0 if none.	Peter Eisentraut	19:43

March 15, 2009

Thread	Author	Time
Oracle to PostgreSQL	Greenhorn	23:35
Re: Oracle to PostgreSQL	John R Pierce	23:41
Re: Oracle to PostgreSQL	Thomas Kellerer	23:53

March 16, 2009

Thread	Author	Time
Re: Oracle to PostgreSQL	John R Pierce	00:06
Re: [SQL] Oracle to PostgreSQL	Marcin Stępnicki	14:30
RE: [SQL] RE : [SQL] Convert text from UTF8 to ASCII	Paul Dam	14:44
Exclude fields from SELECT command	Charles Tam	20:56
Re: Exclude fields from SELECT command	Pavel Stehule	21:45

March 17, 2009

Thread	Author	Time
Re: Exclude fields from SELECT command	Ashish Karalkar	05:17
Re: Exclude fields from SELECT command	Pavel Stehule	05:27
Methods declaration	Gianvito Pio	06:39
diff b/w varchar(N) & text	sathiya psql	11:02
Re: Exclude fields from SELECT command	sathiya psql	11:04
Re: diff b/w varchar(N) & text	Frank Bax	13:12
SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps	Srikanth	14:50
Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps	Richard Huxton	15:06
Re: Methods declaration	Tom Lane	16:56
Re: Exclude fields from SELECT command	Steve Midgley	18:49
join	Ivan Sergio Borgonovo	21:40
How do I optimize this?	Wei Weng	21:43
Re: How do I optimize this?	Wei Weng	22:37

March 18, 2009

Thread	Author	Time
2 left join taking in too many records, 1 join and 1 left join too few was: join	Ivan Sergio Borgonovo	08:16
Re: How do I optimize this?	Richard Huxton	08:35
Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps	Srikanth	16:02

March 19, 2009

Thread	Author	Time
alter table on a large db	Zdravko Balorda	07:57
Re: alter table on a large db	Achilleas Mantzios	08:30
Re: alter table on a large db	Scott Marlowe	11:17
Re: alter column from varchar(32) to varchar(255) without view re-creation	Emi Lu	14:54
Relatorio da composiçao de FKs e PKs	paulo matadr	17:42
Re: [SQL] Relatorio da composiçao de FKs e PKs	Oliveiros Cristina	17:47
Re: Re: [SQL] Relatorio da composiçao de FKs e PKs	Alvaro Herrera	18:11

March 20, 2009

Thread	Author	Time
simple SQL question	Kevin Duffy	19:06
Postgresql Rules	Staten Oliver	19:54
Re: simple SQL question	Kevin Duffy	21:20
pg_restore error - Any Idea?	DM	22:40

March 23, 2009

Thread	Author	Time
bash & postgres	Greenhorn	04:03
Re: bash & postgres	Harvey, Allan AC	04:18
pg_restore error - Any Idea?	DM	05:44
Re: pg_restore error - Any Idea?	Erik Jones	06:17
Re: [SQL] bash & postgres	Erik Jones	06:31
cast bool/int	Zdravko Balorda	07:59
Re: bash & postgres	Ivan Sergio Borgonovo	08:09
Re: cast bool/int	Achilleas Mantzios	08:15
Re: cast bool/int	Achilleas Mantzios	08:18
Re: [SQL] bash & postgres	Tom Lane	14:05
Re: cast bool/int	Joshua Tolley	14:33
Re: cast bool/int	Marcin Krawczyk	14:44
Re: cast bool/int	Zdravko Balorda	14:45
Re: pg_restore error - Any Idea?	DM	15:04
Re: [SQL] bash & postgres	Erik Jones	19:04
Re: [SQL] bash & postgres	Tom Lane	19:55

March 24, 2009

Thread	Author	Time
Alter Table/Indexing	Zdravko Balorda	08:55
Re: alter table on a large db	Jasen Betts	09:15
Re: cast bool/int	Jasen Betts	09:28
Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps	Jasen Betts	09:39
Re: Alter Table/Indexing	Tom Lane	14:35
Proper entry of polygon type data	Peter Willis	15:10

March 25, 2009

Thread	Author	Time
Re: Alter Table/Indexing	Steve Midgley	15:49
Special sort querstion	Dominik Piekarski	16:51
Can we load all database objects in memory?	DM	19:20
Re: [SQL] Can we load all database objects in memory?	ries van Twisk	19:59
Re: [SQL] Can we load all database objects in memory?	ries van Twisk	20:07
Re: Can we load all database objects in memory?	Iñigo Martinez Lasala	20:09
Re: [SQL] Can we load all database objects in memory?	Iñigo Martinez Lasala	20:11
Re: [SQL] Can we load all database objects in memory?	Scott Marlowe	20:12

March 26, 2009

Thread	Author	Time
Table to Excel	Nicholas I	06:35
Re: Table to Excel	Pavel Stehule	07:04
Re: [ADMIN] Can we load all database objects in memory?	Albe Laurenz	09:44
Re: Table to Excel	Josh Trutwin	14:05
Re: Table to Excel	Pavel Stehule	16:30
Re: Can we load all database objects in memory?	Steve Midgley	16:38

March 27, 2009

Thread	Author	Time
Add: Special sort querstion	Dominik Piekarski	12:10
Re: Table to Excel	Greenhorn	16:27

March 28, 2009

Thread	Author	Time
Re: Table to Excel	Jasen Betts	11:57

March 29, 2009

Thread	Author	Time
a bit confused about distinct() function	Tena Sakai	17:27
Re: a bit confused about distinct() function	Osvaldo Kussama	17:44
Re: a bit confused about distinct() function	Tom Lane	17:49
Re: a bit confused about distinct() function	Tena Sakai	18:02
Re: a bit confused about distinct() function	Tena Sakai	18:03

March 30, 2009

Thread	Author	Time
xpath_table, or something similair?	Mario Splivalo	08:41

Browse Archives

Prev | Next