pgsql-sql since 1999-03-26 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

March 26, 1999

Thread Author Time
Odd "problem", not sure if there is a solution .... The Hermit Hacker 03:46
Re: [GENERAL] Re: [SQL] sql 92 support in postgres Oleg Broytmann 09:54
RE: [SQL] Odd "problem", not sure if there is a solution .... Jackson, DeJuan 16:29
Re: [SQL] Odd "problem", not sure if there is a solution .... secret 20:08
newbie question about type conversions Andrew Douglas 21:13
newbie question about type conversions Andrew Douglas 21:42

March 27, 1999

Thread Author Time
Determining if "in a text set" Richi Plana 04:41

March 28, 1999

Thread Author Time
Re: [SQL] Odd "problem", not sure if there is a solution .... Herouth Maoz 15:48
Re: [GENERAL] Determining if "in a text set" Herouth Maoz 17:24
Re: [SQL] Re: [GENERAL] Determining if "in a text set" Herouth Maoz 17:44
Re: [SQL] Re: [GENERAL] Determining if "in a text set" Richi Plana 18:10
Re: [GENERAL] Determining if "in a text set" Richi Plana 18:56
Re: [SQL] Re: [GENERAL] Determining if "in a text set" Richi Plana 19:11

March 29, 1999

Thread Author Time
inheritance and selection Francois TETE 08:29
inheritance and update Francois TETE 08:34
Inheritance and selection Francois TETE 08:41
Inheritance and update Francois TETE 08:42
Re: [GENERAL] Determining if "in a text set" Herouth Maoz 10:34
IIF.. Eduardo Noeda 10:49
Returning an integer from a date Rick Dearman 10:51
pgsql and function results erikp 11:02
Re: [GENERAL] Returning an integer from a date Adriaan Joubert 11:22
Newbie question about datatype conversion Andrew Douglas 13:47
Re: [GENERAL] Returning an integer from a date Herouth Maoz 16:00
RE: [SQL] IIF.. Jackson, DeJuan 19:20
union on views Gregory Holston 20:19
RE: [SQL] union on views Jackson, DeJuan 20:30
Re: [SQL] IIF.. Clark Evans 21:34
Re: [SQL] union on views] Bruce Momjian 22:59

March 30, 1999

Thread Author Time
Re: [SQL] IIF.. Clark Evans 00:01
RE: [SQL] IIF.. Jackson, DeJuan 00:31
SELECT (CASE ... ) gives copyObject error in current CVS build. Clark Evans 02:43
indexing a datetime by date Andrew Merrill 03:27
RE: [SQL] indexing a datetime by date Jackson, DeJuan 04:07
Re: [SQL] indexing a datetime by date Thomas Lockhart 06:14
Re: [GENERAL] Returning an integer from a date Herouth Maoz 11:51
RE: [SQL] indexing a datetime by date Herouth Maoz 11:59
sorting by date & time in descending order ?? Ralf Weidemann 13:38
Re: [GENERAL] sorting by date & time in descending order ?? Herouth Maoz 14:00
How to do this in SQL? Chris Bitmead 14:45
Re: [GENERAL] sorting by date & time in descending order ?? Kollar Lajos 14:49
Re: [GENERAL] How to do this in SQL? Herouth Maoz 14:59
Re: [GENERAL] How to do this in SQL? Chris Bitmead 15:03
Re: [GENERAL] How to do this in SQL? Herouth Maoz 15:13
Re: [GENERAL] How to do this in SQL? Stuart Rison 15:50
Date operation efficiency Oliver Smith 16:00
Re: [SQL] indexing a datetime by date Tom Lane 16:31
RE: [SQL] indexing a datetime by date Jackson, DeJuan 17:21
Re: [SQL] indexing a datetime by date Andrew Merrill 17:25
RE: [SQL] indexing a datetime by date Jackson, DeJuan 17:33
regexp strangeness Andrew Merrill 17:44
Re: [SQL] indexing a datetime by date Andrew Merrill 18:11
Selecting and deleting duplicate rows Clark Evans 20:33

March 31, 1999

Thread Author Time
merging date and time Marco.Iannacone 08:44
TO_CHAR or TO_DATE Chairudin Sentosa 11:34
Re: [SQL] Odd "problem", not sure if there is a solution .... Chairudin Sentosa 13:11
merging date and time miannaco 14:03
Re: [SQL] TO_CHAR or TO_DATE Clark Evans 14:27
error -dl- ZioBudda 14:46
Help Kaza 15:58
Re: [SQL] merging date and time Ross J. Reedstrom 16:01
Re: [SQL] merging date and time Oliver Smith 16:16
RE: [SQL] Odd "problem", not sure if there is a solution .... Jackson, DeJuan 16:54
select ... from (select .. from where.. ) where ... ? MESZAROS Attila 19:35
Re: [SQL] select ... from (select .. from where.. ) where ... ? Clark Evans 20:00
Retrieving the record not matched with a join. Frans de Wet 20:53
RE: [SQL] Retrieving the record not matched with a join. Jackson, DeJuan 21:06

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

Browse Archives

Prev | Next