pgsql-sql - April 1999

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 9 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 1, 1999

Thread Author Time
Finding strange patters Richi Plana 00:57
How do I return values that begin with non-alphabet characters from a search? Robert Chalmers 03:53

April 9, 1999

Thread Author Time
Re: [SQL] Nested subqueries in the target list Vadim Mikheev 12:54
Re: [SQL] how to retrieve... ZioBudda 13:17
Nested subqueries in the target list Jens Glaser 17:38
Nested subqueries in the target list Jens Glaser 17:41
Re: [SQL] how to retrieve... Ross J. Reedstrom 23:37

April 11, 1999

Thread Author Time
aggregate functions and varchar type Will Benton 23:30

April 12, 1999

Thread Author Time
Re: [SQL] aggregate functions and varchar type José Soares 13:18
subqueries Walt Bigelow 18:58

April 13, 1999

Thread Author Time
Re: [SQL] subqueries Walt Bigelow 13:12
Trouble with null text fields! Glenn Waldron 15:18
Trouble with null text fields Glenn Waldron 15:25
Re: [SQL] subqueries Tom Lane 15:37
RE: [SQL] Trouble with null text fields Michael Davis 15:48
RE: [SQL] Trouble with null text fields Michael Davis 16:01
Re: [SQL] Trouble with null text fields José Soares 16:07
bug report on text text fields. WAS: Re: [SQL] Trouble with ... David Sauer 16:16
Re: [SQL] subqueries Tom Lane 23:31

April 14, 1999

Thread Author Time
external environment variable Randal Flagg 03:02
inet problem Olivier BLONDEAU 08:45
Re: [SQL] inet problem D'Arcy J.M. Cain 12:15
Re: [SQL] inet problem Olivier BLONDEAU 12:52
Re: [SQL] external environment variable José Soares 13:40

April 15, 1999

Thread Author Time
Re: [SQL] external environment variable Tom Lane 14:54
[SQL] OUTER JOINS Dan Janowski 18:21
[SQL] OUTER JOINS Dan Janowski 20:11

April 16, 1999

Thread Author Time
[No subject] Lucas Di Pentima 02:25
[No subject] Lucas Di Pentima 02:26
UPDATE subselect? Chris Bitmead 13:10
Re: [SQL] Update on 6.5 José Soares 13:28
Re: [SQL] UPDATE subselect? José Soares 14:58
Re: [SQL] UPDATE subselect? Chris Bitmead 15:27
Update on 6.5 Chairudin Sentosa 15:47
RE: [SQL] UPDATE subselect? Jackson, DeJuan 16:35
How to compare Datetime Henrik Pedersen 16:38
php for pgsql for windows Dr. Alexey A. Terent'ev 18:38
Strange behaviour with date costants.... Daniele Orlandi 21:23

April 17, 1999

Thread Author Time
Re: [SQL] How to compare Datetime Tom Lane 15:46
[No subject] Ady-55 20:49

April 18, 1999

Thread Author Time
Impossible query with SQL? or not? david 00:54
PL/TCL and NULL values Daniele Orlandi 01:37
Re: [SQL] Trouble with null text fields! Tom Lane 17:51
Case insensitive searchs Andy Lewis 18:14
Re: [SQL] Case insensitive searchs Gregory W Burnham 18:16
Re: [SQL] Case insensitive searchs Andy Lewis 18:31
Re: [SQL] Case insensitive searchs Ross J. Reedstrom 18:44
Re: [SQL] Case insensitive searchs Ross J. Reedstrom 18:51
Re: [SQL] Case insensitive searchs Andy Lewis 18:58
postgres 6.3.2 and regexp Bill Brandt 23:37

April 19, 1999

Thread Author Time
Re: [SQL] OUTER JOINS Joe Shevland 06:26
Re: [SQL] postgres 6.3.2 and regexp Guido Piazzi 12:54
Re: [SQL] OUTER JOINS Dan Janowski 13:26
Re: [SQL] postgres 6.3.2 and regexp Tom Lane 13:38
RE: [SQL] OUTER JOINS Michael J Davis 15:16
RE: [SQL] OUTER JOINS Michael J Davis 15:18
Re: [SQL] Case insensitive searchs D'Arcy J.M. Cain 16:25
6.4.2 and LEFT/RIGHT OUTER JOIN Giovanni Battista, Stefanoni 20:17
VACUUM in a trigger Brett W. McCoy 20:48
Re: [SQL] VACUUM in a trigger Brian 21:35
problem when vacuuming. . . JT Kirkpatrick 22:24

April 20, 1999

Thread Author Time
Re: [INTERFACES] where did that date and time come from?? Screech 00:07
FW: [SQL] OUTER JOINS Michael J Davis 02:10
RE:[SQL] OUTER JOINS Michael J Davis 02:10
Questions about embedded-sql! Anna Langer 02:18
RE: [SQL] OUTER JOINS Michael J Davis 02:34
RE: [SQL] OUTER JOINS Michael J Davis 02:34
Re: [SQL] OUTER JOINS Joe Shevland 03:33
RE: [SQL] OUTER JOINS Michael J Davis 05:30
Re: [SQL] Questions about embedded-sql! Magnum Ind. da Amazonia S/A 12:30
Re: [GENERAL] problem when vacuuming. . . Karl DeBisschop 13:17
Re: [SQL] Questions about embedded-sql! Maarten Boekhold 14:10
Re: [SQL] Questions about embedded-sql! Tom Lane 14:35
Re: [INTERFACES] where did that date and time come from?? Thomas Lockhart 14:40
SELECT LIMIT not working with unions? Dirk Lutzebaeck 15:11
null values to be replaced by a default value Nuchanard Chiannilkulchai 15:31
RE: [SQL] null values to be replaced by a default value Michael J Davis 17:13
Re: [SQL] null values to be replaced by a default value Tom Lane 17:20
TUPLES <> HEAP JT Kirkpatrick 18:58
Re: [GENERAL] TUPLES <> HEAP Karl DeBisschop 19:08
Re: [INTERFACES] TUPLES <> HEAP Ken J. Wright 19:13

April 21, 1999

Thread Author Time
Re: [SQL] Update on 6.5 Chairudin Sentosa 08:36
Re: [SQL] Update on 6.5 José Soares 12:39
perl and postgres. . . JT Kirkpatrick 15:45
convert text to number or number to text JT Kirkpatrick 18:34
Re: [SQL] perl and postgres. . . Brett W. McCoy 19:10

April 22, 1999

Thread Author Time
default in ALTER novikov 10:19
Re: [SQL] default in ALTER George Moga 11:33
Re: [SQL] convert text to number or number to text José Soares 12:24
Re: [SQL] convert text to number or number to text José Soares 12:29
UNION with grouping? Bill Carlson 14:05
Finding the "most recent" rows Julian Scarfe 14:14
SELECT TOP _x_ ?? Justin Long 14:33
Re: [SQL] SELECT TOP _x_ ?? Chris Bitmead 14:42
Re: [SQL] Finding the "most recent" rows Chris Bitmead 14:45
Re: [SQL] Finding the "most recent" rows 📎 George Moga 14:46
RE: [SQL] Finding the "most recent" rows Michael J Davis 14:53
Re: [SQL] Finding the "most recent" rows Tom Lane 15:29
sum of two queries Kyle Bateman 17:26
RE: [SQL] sum of two queries Michael J Davis 17:48
Re: [SQL] sum of two queries Kyle Bateman 18:15
[No subject] Daniel Facciolo Pires 18:32
Re: [SQL] Finding the "most recent" rows Brook Milligan 18:51
SELECT TOP X -- part 2 -- parse error? Justin Long 18:52
Index on date_trunc Christophe Labouisse 20:21
backend closing channel unexpectedly JT Kirkpatrick 20:32
RE: [SQL] SELECT TOP X -- part 2 -- parse error? Michael J Davis 21:12
RE: [SQL] SELECT TOP X -- part 2 -- parse error? Justin Long 21:23
Re: [SQL] sum of two queries G. Anthony Reina 21:23
RE: [SQL] SELECT TOP X -- part 2 -- parse error? Michael J Davis 21:42
Changing the editor for the \e option G. Anthony Reina 21:46
Re: [SQL] Changing the editor for the \e option John M. Flinchbaugh 22:01
Re: [SQL] Changing the editor for the \e option G. Anthony Reina 22:13
Replacing PREPARE Paul E Stephens 23:39
Re: [SQL] Finding the "most recent" rows Chris Bitmead 23:57

April 23, 1999

Thread Author Time
Re: [SQL] SELECT TOP X -- part 2 -- parse error? Chris Bitmead 00:18
Re: [SQL] Finding the "most recent" rows Tom Lane 00:45
Re: [SQL] Changing the editor for the \e option Brett W. McCoy 01:03
Re: [SQL] Finding the "most recent" rows Chris Bitmead 02:00
Re: [SQL] Finding the "most recent" rows Chris Bitmead 02:30
Re: [SQL] SELECT TOP _x_ ?? Chris Bitmead 02:34
Re: [SQL] Finding the "most recent" rows Tom Lane 04:08
Re: [SQL] Finding the "most recent" rows Brook Milligan 04:10
Re: [SQL] Finding the "most recent" rows Chris Bitmead 04:39
Re: [INTERFACES] where did that date and time come from?? Thomas Lockhart 05:21
Re: [SQL] Finding the "most recent" rows Chairudin Sentosa 08:30
Re: [SQL] Finding the "most recent" rows Chairudin Sentosa 08:34
Re: [SQL] SELECT TOP _x_ ?? Chairudin Sentosa 08:36
Re: [INTERFACES] where did that date and time come from?? Chairudin Sentosa 09:13
Re: [SQL] Finding the "most recent" rows Julian Scarfe 10:30
Re: [SQL] SELECT TOP X -- part 2 -- parse error? José Soares 14:25
FW: [SQL] SELECT TOP _x_ ?? Justin Long 14:33
Re: [SQL] Finding the "most recent" rows Brook Milligan 14:42
Large objects - bug? caveat? feature? Justin Long 15:04
Re: [SQL] Finding the "most recent" rows Tom Lane 16:06
Re: [SQL] Finding the "most recent" rows Tom Lane 16:29
Re: [HACKERS] Re: [SQL] Finding the "most recent" rows Bruce Momjian 19:43
what is "cost"? Gregory Holston 20:09
Re: [SQL] what is "cost"? Bruce Momjian 21:24
Re: [SQL] what is "cost"? Gregory Holston 21:27
Re: [SQL] what is "cost"? Bruce Momjian 21:29

April 24, 1999

Thread Author Time
Re: [SQL] Large objects - bug? caveat? feature? Chris Bitmead 02:58
Percentages? Chris Bitmead 12:05

April 25, 1999

Thread Author Time
Relating 1 table to another. Nigel Tamplin 08:10
Confusion about DISTINCT. Chris Bitmead 09:23
Re: [SQL] Confusion about DISTINCT. Tom Lane 16:22
Re: [SQL] Relating 1 table to another. Tom Lane 16:47
PL/pgsql questions.. tveith 17:10
Primary Key Bugs Tim Perdue 17:59

April 26, 1999

Thread Author Time
Re: [SQL] PL/pgsql questions.. Jan Wieck 07:31
Re: [SQL] Primary Key Bugs José Soares 12:44
substring Nuchanard Chiannilkulchai 14:57
CURRVAL(INDEX) Justin Long 15:52
RE: [SQL] substring Michael J Davis 19:35
Strange behavior 📎 Christophe Labouisse 19:37
Re: [SQL] Strange behavior Tom Lane 21:23

April 27, 1999

Thread Author Time
Re: [SQL] Strange behavior 📎 Christophe Labouisse 06:03
Re: [SQL] substring Nuchanard Chiannilkulchai 08:15
Re: [SQL] Percentages? Nuchanard Chiannilkulchai 08:20
Re: [SQL] Percentages? 📎 José Soares 12:50
Re: [SQL] substring José Soares 13:01
Arrays and count () Mr M Pacey 13:48
Arrays and count() Mr M Pacey 14:04
RE: [SQL] substring Michael J Davis 14:06
rules help Brook Milligan 14:26
Re: [SQL] Strange behavior Tom Lane 14:31
Re: [SQL] substring Tom Lane 14:36
Re: [SQL] Arrays and count() Tom Lane 15:07
Re: [SQL] substring José Soares 15:18
Re: [SQL] rules help Jan Wieck 15:45
Re: [SQL] rules help Brook Milligan 17:20
Re: [SQL] Strange behavior 📎 Christophe Labouisse 18:35
filling an empty table w/ defaults defined JT Kirkpatrick 19:57
incrementing by the second JT Kirkpatrick 20:13
RE: [SQL] filling an empty table w/ defaults defined Jackson, DeJuan 20:37
RE: [SQL] incrementing by the second Jackson, DeJuan 20:41
RE: [SQL] incrementing by the second JT Kirkpatrick 21:16
Re: [SQL] Strange behavior Tom Lane 21:55

April 28, 1999

Thread Author Time
Re: [SQL] Strange behavior 📎 Christophe Labouisse 05:22
Re: [SQL] substring Nuchanard Chiannilkulchai 12:02
Re: [SQL] OUTER JOINS Herouth Maoz 15:58
[No subject] Eric Vernichon 20:56

April 29, 1999

Thread Author Time
LIMIT Mr. Poet 05:22
Re: [SQL] LIMIT Chris Bitmead 05:47
Re: [SQL] LIMIT Dirk Lutzebaeck 08:06