pgsql-sql since 2010-06-23 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 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
Re: grouping subsets	Rainer Stengele	13:25
Re: grouping subsets	Tim Landscheidt	14:18
Re: Aggregates (last/first) not behaving	Wes Devauld	15:50
Re: Aggregates (last/first) not behaving	Tim Landscheidt	18:42
Re: Aggregates (last/first) not behaving	Richard Huxton	19:24

July 23, 2010

Thread	Author	Time
[TRIGGER] Returning values from BEFORE UPDATE trigger, without using them	Torsten Zühlsdorff	12:53

July 24, 2010

Thread	Author	Time
howto delete using a join ?	Andreas	04:05
Re: howto delete using a join ?	Dmitriy Igrishin	09:22
Re: howto delete using a join ?	Joshua Tolley	11:47

July 26, 2010

Thread	Author	Time
Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them	Torsten Zühlsdorff	07:41
Returning only alphanumeric values from a query	Enrique Palacios	13:55
Re: Returning only alphanumeric values from a query	Osvaldo Kussama	15:44

July 27, 2010

Thread	Author	Time
Re: grouping subsets	Oliveiros d'Azevedo Cristina	10:37
Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them	Tom Lane	20:50

July 28, 2010

Thread	Author	Time
Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them	Torsten Zühlsdorff	06:45
how to escape _ in select	Wes James	17:35
Re: how to escape _ in select	Wes James	18:07
Re: how to escape _ in select	Tom Lane	18:34
Re: how to escape _ in select 📎	Justin Graf	18:47
Re: how to escape _ in select	Wes James	18:52
Re: how to escape _ in select	Wes James	20:23
Re: how to escape _ in select	Dmitriy Igrishin	20:44

July 29, 2010

Thread	Author	Time
Re: how to escape _ in select	Thomas Kellerer	07:16
Re: grouping subsets	Rainer Stengele	09:41
Re: grouping subsets	Oliveiros d'Azevedo Cristina	11:47
Re: grouping subsets	Rainer Stengele	12:10
How to get geometry enabled Tables form Postgresql/postgis	venkat	12:58
Re: grouping subsets	Oliveiros d'Azevedo Cristina	13:31
join table problem	Jedrin	16:35
Re: How to get geometry enabled Tables form Postgresql/postgis 📎	Lee Hachadoorian	20:13

July 30, 2010

Thread	Author	Time
Re: How to get geometry enabled Tables form Postgresql/postgis	venkat	04:27
Re: grouping subsets	Rainer Stengele	09:35
Re: grouping subsets	Oliveiros d'Azevedo Cristina	15:07
Re: grouping subsets	Joshua Tolley	15:58

July 31, 2010

Thread	Author	Time
Re: grouping subsets	Rainer Stengele	19:48

Aug. 3, 2010

Thread	Author	Time
What does PostgreSQL do when time goes backward?	John Hasler	00:03
Help Need some hindsight	Andreas	02:58
aggregate function	Viktor Bojović	14:38
Re: aggregate function	Tom Lane	14:48
Backslash characters in PLPGSQL	Garrett Murphy	15:05
Re: Backslash characters in PLPGSQL	Tom Lane	15:54
How do you do the opposite of regexp_split_to_table?	John Gage	20:21
Re: How do you do the opposite of regexp_split_to_table?	Alvaro Herrera	20:35

Aug. 4, 2010

Thread	Author	Time
workaround for missing ROWNUM feature with the help of GUC variables	Marc Mamin	10:35
Re: join table problem	Oliveiros d'Azevedo Cristina	11:11
Re: What does PostgreSQL do when time goes backward?	Frank Bax	11:20
Re: Help Need some hindsight	A. Kretschmer	11:48
Re: What does PostgreSQL do when time goes backward?	Kenneth Marshall	12:55
Some quick questions	Joshua Gooding	14:22
Re: Some quick questions	Kenneth Marshall	14:43
Using SKYLINE command on PostgreSQL	LaboRecherche	16:26
Re: What does PostgreSQL do when time goes backward?	John Hasler	16:56
Domains, casts, and MS Access	Peter Koczan	17:31
Re: Domains, casts, and MS Access	Richard Broersma	17:47
Re: What does PostgreSQL do when time goes backward?	Steve Wampler	17:50
Re: Domains, casts, and MS Access	Peter Koczan	18:51
Re: Domains, casts, and MS Access	Richard Broersma	18:56
Re: workaround for missing ROWNUM feature with the help of GUC variables	Andreas Joseph Krogh	20:07
Re: Domains, casts, and MS Access 📎	Justin Graf	20:24

Browse Archives

Prev | Next