pgsql-sql since 2010-06-04 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

June 4, 2010

Thread	Author	Time
sum an alias	Wes James	02:16
Re: sum an alias	A. Kretschmer	05:54
Re: how to construct sql	Jasen Betts	10:01
Re: sum an alias	Wes James	13:30
Re: sum an alias	Oliveiros d'Azevedo Cristina	13:44

June 6, 2010

Thread	Author	Time
Difference between these two queries ?	Nilesh Govindarajan	02:30
Re: [SQL] Difference between these two queries ?	Sergey Konoplev	09:04
Re: inner join and limit	msi77	14:58
Re: [SQL] Difference between these two queries ?	Little, Douglas	15:15
Re: [SQL] Difference between these two queries ?	Sam Mason	15:36
Re: Difference between these two queries ?	Nilesh Govindarajan	16:34

June 7, 2010

Thread	Author	Time
Multiple subquery with insert into command ?	reyman	16:22
Re: Multiple subquery with insert into command ?	msi77	16:59
Re: Multiple subquery with insert into command ?	reyman	22:25

June 8, 2010

Thread	Author	Time
Casts in foreign schemas	Ben Morrow	14:33
Re: Casts in foreign schemas	Tom Lane	14:50
Some insight on the proper SQL would be appreciated	Aaron Burnett	17:04
Re: Some insight on the proper SQL would be appreciated	Oliveiros d'Azevedo Cristina	17:55
Re: Some insight on the proper SQL would be appreciated	Mikhail V. Puzanov	17:58
Re: Some insight on the proper SQL would be appreciated	Aaron Burnett	18:16
Re: Some insight on the proper SQL would be appreciated	Aaron Burnett	18:20

June 10, 2010

Thread	Author	Time
what does this do	John	09:22
Re: what does this do	Tim Landscheidt	10:57
Re: what does this do	Richard Broersma	13:42
Re: what does this do	Little, Douglas	13:46
Re: what does this do	John	14:03
Re: what does this do	Tim Landscheidt	14:56
Returning to default (e.g. blank) table permissions after a revoke?	Bryce Nesbitt	18:48

June 11, 2010

Thread	Author	Time
is there a tutorial on window functions?	John	14:17
Re: is there a tutorial on window functions?	Andreas Kretschmer	14:37
Re: is there a tutorial on window functions?	Thomas Kellerer	14:39
Re: is there a tutorial on window functions?	Kenneth Marshall	14:49
Re: is there a tutorial on window functions?	John	14:54

June 15, 2010

Thread	Author	Time
oracle to postgres migration question	Joshua Gooding	19:09
Re: oracle to postgres migration question	Bruce Momjian	19:54
Re: oracle to postgres migration question	Scott Marlowe	20:07
Re: oracle to postgres migration question	Stephen Frost	20:17
Re: oracle to postgres migration question	Stephen Frost	20:19
Re: oracle to postgres migration question	Reinoud van Leeuwen	21:10
Re: oracle to postgres migration question	Scott Marlowe	21:14
Re: oracle to postgres migration question	Bruce Momjian	22:45

June 16, 2010

Thread	Author	Time
Re: oracle to postgres migration question	silly sad	05:02
Re: oracle to postgres migration question	Joshua Gooding	11:50
Re: oracle to postgres migration question	Stephen Frost	12:28
Re: oracle to postgres migration question	Chris Browne	19:42
Re: oracle to postgres migration question	Scott Marlowe	20:53

June 18, 2010

Thread	Author	Time
running scripts like oracle sqlplus	Steven Dahlin	22:24

June 20, 2010

Thread	Author	Time
error on line 1 trying to execute a script using psql	Steven Dahlin	21:53

June 21, 2010

Thread	Author	Time
Re: running scripts like oracle sqlplus	Kenneth Marshall	18:52
Re: running scripts like oracle sqlplus	Brian Sherwood	21:01
Re: error on line 1 trying to execute a script using psql	Tim Landscheidt	21:44

June 22, 2010

Thread	Author	Time
Re: error on line 1 trying to execute a script using psql	A. Kretschmer	05:08
How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL	venkat	10:48
Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL	Thom Brown	14:38
Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL	Stephane Bortzmeyer	14:40
Re: [SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL	Pavel Stehule	14:40
ORDER BY is case insensitive	Bryan White	20:52
Re: ORDER BY is case insensitive	Gerardo Herzig	21:32
Re: ORDER BY is case insensitive	Tom Lane	21:40

June 23, 2010

Thread	Author	Time
Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL	silly sad	06:11
Re: ORDER BY is case insensitive	Jasen Betts	13:45
Re: COPY command and required file permissions	bruno.scovoli	21:01

June 24, 2010

Thread	Author	Time
Re: ORDER BY is case insensitive	silly sad	04:49
question about partitioning	Joshua Gooding	13:05
Re: question about partitioning	Jasen Betts	15:06
Re: ORDER BY is case insensitive	Bryan White	17:26
Re: question about partitioning	Joshua Gooding	19:31
Re: question about partitioning	Little, Douglas	19:37
Re: question about partitioning	Joshua Gooding	19:51
Re: question about partitioning 📎	Petru Ghita	20:17
differences between function returning 'setof table' and 'table'	Gerardo Herzig	22:26

June 25, 2010

Thread	Author	Time
Average of Array?	Lee Hachadoorian	16:21
Re: Average of Array?	Tom Lane	16:29
Re: Average of Array?	Pavel Stehule	16:29
Re: Average of Array?	Lee Hachadoorian	16:34
enforcing constraints across multiple tables	Andrew Geery	17:52
Re: COPY command and required file permissions	Adrian Klaver	18:37
Re: enforcing constraints across multiple tables	Tim Landscheidt	19:01
Re: Average of Array?	Ireneusz Pluta	19:33
How do I remove selected words from text field?	Frank Bax	22:23
Round integer division	Lee Hachadoorian	22:53
Re: Round integer division	Scott Marlowe	23:00
Re: Round integer division	Lee Hachadoorian	23:07
Re: Round integer division	Adrian Klaver	23:25
Re: How do I remove selected words from text field?	Osvaldo Kussama	23:28
Re: Round integer division	Lee Hachadoorian	23:32

June 26, 2010

Thread	Author	Time
Re: enforcing constraints across multiple tables	Ben Morrow	01:19
Re: COPY command and required file permissions	Adrian Klaver	01:51
Re: How do I remove selected words from text field?	Frank Bax	12:30
Re: How do I remove selected words from text field?	Frank Bax	13:03
Re: Round integer division	Jasen Betts	13:09
Re: Round integer division	Jasen Betts	13:18

June 28, 2010

Thread	Author	Time
Re: round(Numeric)	silly sad	05:29
Re: help	Marcin Krawczyk	06:46
Outer join construction step :strange results	ced	10:03
Re: Outer join construction step :strange results	Oliveiros d'Azevedo Cristina	11:10
Re: Outer join construction step :strange results	ced	11:28
Re: Outer join construction step :strange results	Oliveiros d'Azevedo Cristina	12:40
Re: Outer join construction step :strange results	ced	13:46
Re: Outer join construction step :strange results	Oliveiros d'Azevedo Cristina	13:51
Re: Outer join construction step :strange results	ced	14:22

June 29, 2010

Thread	Author	Time
How to select text field as interger	Jerrel Kemper	20:51
Re: How to select text field as interger	Tim Landscheidt	21:06
Re: How to select text field as interger	Tom Lane	22:07

June 30, 2010

Thread	Author	Time
Re: How to select text field as interger	silly sad	08:12
Invitation to connect on LinkedIn	Eduardo Schweigert	17:13
Invitation to connect on LinkedIn	Eduardo Schweigert	18:28

July 1, 2010

Thread	Author	Time
Re: How do I remove selected words from text field?	Frank Bax	15:56
Re: How do I remove selected words from text field?	Osvaldo Kussama	23:11
Re: How do I remove selected words from text field?	Frank Bax	23:25

July 2, 2010

Thread	Author	Time
Re: How do I remove selected words from text field?	silly sad	09:02
Domains based on composite types.	Dmitriy Igrishin	09:15
Cant execute the query	Srikanth Kata	12:24

July 5, 2010

Thread	Author	Time
How to store Byte strings into a table.	Trinath Somanchi	05:57
Re:	silly sad	06:12
Re:	Trinath Somanchi	06:30
Re:	Pavel Stehule	06:35
Re:	silly sad	06:36
Re:	Pavel Stehule	06:43
Re: How to store Byte strings into a table.	Sergey Konoplev	06:45
Re:	silly sad	06:56
Re:	Pavel Stehule	07:03
Re:	silly sad	07:10
Re:	Pavel Stehule	07:18
Re:	silly sad	07:28
Re:	Pavel Stehule	07:51

July 6, 2010

Thread	Author	Time
Re: 📎	Justin Graf	17:52
How To Calculate Table Size Minus Deleted Rows	Brian Helm	19:42

July 7, 2010

Thread	Author	Time
Re:	silly sad	05:00
How to Get Column Names from the Table	venkat	09:08
Re: How to Get Column Names from the Table	AI Rumman	09:13
Re: [SQL] How to Get Column Names from the Table	Viktor Bojović	09:14
Re: How to Get Column Names from the Table	A. Kretschmer	09:14
Re: How to Get Column Names from the Table	venkat	09:17
Re: How to Get Column Names from the Table	Jayadevan M	09:29
Re: [SQL] How to Get Column Names from the Table	Sreelatha G	10:12
Re: [SQL] How to Get Column Names from the Table	venkat	10:14
Re: 📎	Justin Graf	14:35
strangest thing happened	John	19:59
Re: strangest thing happened	John	20:38
tsearch2 and wildcards/pattern matching?	Peter Koczan	20:41
Re: strangest thing happened	Ross J. Reedstrom	20:42
Re: strangest thing happened	Joe Conway	20:45
How to find events within a timespan to each other?	Andreas	21:20
Re: strangest thing happened 📎	Justin Graf	21:25
Re: How to find events within a timespan to each other?	Tim Landscheidt	22:01
Re: strangest thing happened 📎	Justin Graf	22:14
Re: strangest thing happened	John	22:41
Re: tsearch2 and wildcards/pattern matching?	Oleg Bartunov	22:44

July 8, 2010

Thread	Author	Time
Re: tsearch2 and wildcards/pattern matching?	Peter Koczan	01:51
Re: strangest thing happened	Viktor Bojović	06:36
Re:	silly sad	07:31
Re: strangest thing happened	Ben Morrow	07:37
Re:	Dave Page	07:38
Re:	silly sad	08:47
Question about domains.	Dmitriy Igrishin	13:27
Re: strangest thing happened 📎	Justin Graf	14:52
Re: strangest thing happened	Torsten Zühlsdorff	14:57
Re: Question about domains.	Vibhor Kumar	19:41
Re: Cant execute the query	Thomas Kellerer	22:08

July 9, 2010

Thread	Author	Time
Re: Well-formed SQL check in postgres?	Davor J.	07:52

July 10, 2010

Thread	Author	Time
How would I store little key-Nr to text lists?	Andreas	07:57
Re: How would I store little key-Nr to text lists?	Pavel Stehule	09:02

July 13, 2010

Thread	Author	Time
subtract two dates to get the number of days	Campbell, Lance	14:58
Re: subtract two dates to get the number of days	Tom Lane	15:02
Re: subtract two dates to get the number of days	Thomas Kellerer	15:05

July 14, 2010

Thread	Author	Time
Re: subtract two dates to get the number of days	silly sad	05:28
Question on COUNT performance	Anders Østergaard Jensen	11:58
Re: Question on COUNT performance	Reinoud van Leeuwen	12:30
Re: subtract two dates to get the number of days	Jean-David Beyer	12:37
Re: Question on COUNT performance	Joshua Tolley	13:30
Re: Question on COUNT performance	Reinoud van Leeuwen	13:44
Re: subtract two dates to get the number of days	Thomas Kellerer	16:06
Re: Question on COUNT performance	Lee Hachadoorian	16:21
Re: Question on COUNT performance	Lee Hachadoorian	16:49
Re: subtract two dates to get the number of days	Jean-David Beyer	17:05
Re: Question on COUNT performance	Anders Østergaard Jensen	23:49

July 15, 2010

Thread	Author	Time
Re: Question on COUNT performance	Anders Østergaard Jensen	00:14
Re: Question on COUNT performance 📎	Lee Hachadoorian	03:43
Re: subtract two dates to get the number of days	Thomas Kellerer	07:18
Re: Question on COUNT performance	REISS Thomas DSIC BIP	09:16

July 16, 2010

Thread	Author	Time
Presentación	JHONATAN CANO FURAGARO	14:52

July 19, 2010

Thread	Author	Time
How oids of the base data types often change?	Dmitriy Igrishin	10:47
Re: How oids of the base data types often change?	Peter Eisentraut	11:04

July 20, 2010

Thread	Author	Time
Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock	Brett Hoerner	02:06
Re: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock	Rob Sargent	20:33

July 21, 2010

Thread	Author	Time
PostgreSQL ontop of FreeBSD jails, maybe there is still hope!	Achilleas Mantzios	06:47
Re: PostgreSQL ontop of FreeBSD jails, maybe there is still hope!	Dave Page	07:57
Re: PostgreSQL ontop of FreeBSD jails, maybe there is still hope!	Achilleas Mantzios	08:06
UUID for Postgresql 8.4	Trinath Somanchi	12:19
Re: UUID for Postgresql 8.4	A. Kretschmer	12:33
Re: UUID for Postgresql 8.4	MIkhail Puzanov	12:37
Re: UUID for Postgresql 8.4	Kenneth Marshall	12:38

July 22, 2010

Thread	Author	Time
Aggregates (last/first) not behaving	Wes Devauld	06:37
grouping subsets	Rainer Stengele	08:09
Re: Aggregates (last/first) not behaving	Richard Huxton	08:44
Re: grouping subsets	A. Kretschmer	10:02
Re: grouping subsets	Richard Huxton	10:53
Re: grouping subsets	Tim Landscheidt	11:31
Re: grouping subsets	Oliveiros d'Azevedo Cristina	13:18

Browse Archives

Prev | Next