Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] function year! | Herouth Maoz | 09:28 |
| Thread | Author | Time |
|---|---|---|
| The use of sequences 📎 | Roy Sigurd Karlsbakk | 14:40 |
| Re: [GENERAL] The use of sequences | Herouth Maoz | 15:27 |
| Re: [GENERAL] The use of sequences 📎 | Jeremiah Davis | 15:54 |
| Thread | Author | Time |
|---|---|---|
| Cannot read block 0 | Toni Steinhauer | 02:12 |
| Sub-select problem (or bug?) | Mark Dalphin | 03:42 |
| CASE and functions are not working | Ivan Kirillov | 09:56 |
| Appending arrays in a table | G. Anthony Reina | 16:58 |
| Thread | Author | Time |
|---|---|---|
| problem with LIKE predicate and wildcards | Steve Maring | 13:50 |
| CHECK and IN (Sets in general) - What's the story? | k_ogorman | 14:12 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] CHECK and IN (Sets in general) - What's the story? | Holger Mitterwald | 07:30 |
| SQL statement Problem | Chauncey Thorn | 12:38 |
| Implementing transactions (reference) | Fred C. Richards | 16:26 |
| Triggers VS Rules | Jose David Martinez Cuevas | 19:13 |
| Thread | Author | Time |
|---|---|---|
| Subselect in DELETE | Mark Dalphin | 01:11 |
| Maximum field in a table | G.Elangovan | 16:20 |
| Maximum field in a table | G.Elangovan | 16:23 |
| Cursors out of a transaction | David Prieto Carrellan | 16:38 |
| parts of date_part() | Eric McKeown | 23:33 |
| Thread | Author | Time |
|---|---|---|
| this one's simpler | Eric McKeown | 00:06 |
| copy probs | Cho Yan Wong | 02:17 |
| Re: [SQL] this one's simpler | Maarten Boekhold | 07:40 |
| Re: [SQL] copy probs | Jose David Martinez Cuevas | 15:22 |
| Query otimizing possible? | Andreas Schmidt | 15:45 |
| Re: [SQL] parts of date_part() | Brook Milligan | 17:20 |
| Having problems to compile SPI | Jose David Martinez Cuevas | 18:07 |
| RE: [SQL] Having problems to compile SPI | Taral | 18:26 |
| Date vs. Datetime boundaries | Leslie Mikesell | 20:52 |
| excel vs. money data type? | Leslie Mikesell | 21:55 |
| copying rows | Walt Bigelow | 22:38 |
| Once again... triggers 📎 | Jose David Martinez Cuevas | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Indexing datetime | Sergei Barbarash | 06:51 |
| Re: [SQL] copying rows | Herouth Maoz | 08:48 |
| Re: [SQL] parts of date_part() | Herouth Maoz | 08:57 |
| Re: [SQL] excel vs. money data type? | David Hartwig | 12:54 |
| Re: [SQL] excel vs. money data type? | Leslie Mikesell | 15:15 |
| Re: [SQL] parts of date_part() | Leslie Mikesell | 16:53 |
| How do I ??? | Ian Johnston | 20:15 |
| Bug in GROUP BY for INSERT | Pushkar Piggott | 23:34 |
| Thread | Author | Time |
|---|---|---|
| Another bug in GROUP BY for INSERT | Pushkar Piggott | 01:00 |
| Re: [SQL] parts of date_part() | Herouth Maoz | 08:13 |
| Counter | ADM. Diego Cueva | 14:13 |
| copy one to many? | Walt Bigelow | 19:38 |
| Re: [SQL] copy one to many? | Bryan White | 19:56 |
| Absolute value on int2 or int4 field | Chris Johnson | 22:35 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] copy one to many? | Walt Bigelow | 03:06 |
| Re: [SQL] Absolute value on int2 or int4 field | Guido Piazzi | 08:52 |
| Contertine timespan to hours | Shawn T. Walker | 18:17 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Contertine timespan to hours | Herouth Maoz | 08:40 |
| Re: [SQL] copy one to many? | Herouth Maoz | 08:58 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] copy probs | Cho Yan Wong | 00:36 |
| [No subject] 📎 | Johan.F.Strand | 11:47 |
| Thread | Author | Time |
|---|---|---|
| upper() and lower() on varchar | Maarten Boekhold | 10:04 |
| pgaccess-forms. | Johann Spies | 11:57 |
| Re: [SQL] How to Make Case InSensitive??? | Marcio Macedo | 14:14 |
| How to Make Case InSensitive??? | S.Ramaswamy | 16:02 |
| Re: [SQL] How to Make Case InSensitive??? | David Hartwig | 16:21 |
| rename table - primary key index? | Leslie Mikesell | 17:24 |
| Re: [SQL] How to Make Case InSensitive??? | David Hartwig | 17:47 |
| Thread | Author | Time |
|---|---|---|
| indexing datetime | Sergei Barbarash | 07:07 |
| Re: [SQL] upper() and lower() on varchar | Sferacarta Software | 12:33 |
| Re: [SQL] upper() and lower() on varchar | Maarten Boekhold | 13:40 |
| Help with setting up table and importing data. | Ronnie Doggart | 16:48 |
| Thread | Author | Time |
|---|---|---|
| Forming Query | Ronnie Doggart | 11:56 |
| Resp: [SQL] Concatenation in selects | Fidelis Assis | 12:17 |
| Concatenation in selects | James Olin Oden | 13:22 |
| Re: [SQL] Concatenation in selects | James Olin Oden | 14:16 |
| indexing datetime | Sergei Barbarash | 15:11 |
| Resp: RE: Resp: [SQL] Concatenation in selects | Fidelis Assis | 17:54 |
| RE: [SQL] rename table - primary key index? | Jackson, DeJuan | 18:29 |
| RE: Resp: [SQL] Concatenation in selects | Jackson, DeJuan | 18:45 |
| Re: [SQL] Concatenation in selects | Leslie Mikesell | 19:33 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Concatenation in selects | Bruce Momjian | 01:04 |
| Re: [SQL] Forming Query | Federico Passaro | 08:57 |
| [SQL] composite primary keys. | Stuart Rison | 14:21 |
| Re: [SQL] composite primary keys. | Dave | 14:49 |
| DECLARE BINARY CURSOR problem | G. Anthony Reina | 18:38 |
| Thread | Author | Time |
|---|---|---|
| Creating Indexes for MAC and IP Data Types 📎 | Craig Orsinger | 00:15 |
| Re: [SQL] Creating Indexes for MAC and IP Data Types | Bruce Momjian | 01:47 |
| Re: [SQL] Creating Indexes for MAC and IP Data Types | The Hermit Hacker | 04:33 |
| constraints don't work... | Andrew M Tracey | 18:23 |
| Thread | Author | Time |
|---|---|---|
| Datetime in humane format | Richard Lynch | 04:27 |
| Re: [SQL] Datetime in humane format | Herouth Maoz | 11:16 |
| Thread | Author | Time |
|---|---|---|
| Database Client (fwd) | Johann Spies | 19:47 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Datetime in humane format | Eric McKeown | 00:32 |
| (no subject) | jmjang | 01:45 |
| Looking for easy SQL documentation! | Jerome Knobl | 05:27 |
| subscribe | David Ben-Yaacov | 13:08 |
| Re: [SQL] Looking for easy SQL documentation! | Kevin O' Gorman | 14:04 |
| SubQuery speed | andreas.fredriksson | 14:45 |
| Re: [SQL] Looking for easy SQL documentation! | Kevin O' Gorman | 14:54 |
| Re: [SQL] SubQuery speed | Herouth Maoz | 15:10 |
| Re: [SQL] Looking for easy SQL documentation! | Leslie Mikesell | 16:36 |
| Re: [SQL] Creating Indexes for MAC and IP Data Types | Craig Orsinger | 17:22 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] SubQuery speed | Vadim Mikheev | 02:29 |
| Loading Array data from delimited ascii files | Jim Jennis | 13:45 |
| [No subject] | John Palmer | 16:03 |
| Re: [SQL] Loading Array data from delimited ascii files | Eric McKeown | 18:55 |
| RE: | Craig Orsinger | 21:09 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | XuYifeng | 00:53 |
| sorry... ;^) | Thierry VERMAT | 08:45 |
| Thank You | John Palmer | 11:29 |
| TimeStamp for insert/update | Zsolt Varga | 13:54 |
| Binary variable length string | Juan Valero | 17:12 |
| Thread | Author | Time |
|---|---|---|
| connecting with password | Eric McKeown | 02:18 |
| Re: [SQL] connecting with password | Daniele Orlandi | 02:31 |
| Re: [SQL] connecting with password | D'Arcy J.M. Cain | 03:11 |
| Linux ODBC DRIVER ? | Marcio Macedo | 17:21 |
| Re: [SQL] connecting with password | Eric McKeown | 18:12 |
| Thread | Author | Time |
|---|---|---|
| Aggregate functions on DATE and TIME | Sverre H. Huseby | 07:32 |
| Re: [PHPLIB] SQL probs with phplib | Szandor van Verseveld | 09:23 |
| Re: [PHPLIB] SQL probs with phplib | Kristian =?iso-8859-1?Q?K=F6hntopp?= | 09:28 |
| Re: [SQL] SQL probs with phplib | David Hartwig | 20:10 |
| SQL probs with phplib | Oliver Duke-Williams | 23:57 |
| Thread | Author | Time |
|---|---|---|
| CREATE GROUP? | Vladimir Sovetov | 01:16 |
| subscribe pgsql-sql | Howie | 18:43 |
| varchar vs. upper(), lower() etc. | Leslie Mikesell | 18:46 |
| Primary and foreign key | Daniel Facciolo Pires | 21:24 |
| Thread | Author | Time |
|---|---|---|
| create a new user in a group | maloune | 12:33 |
| Re: [SQL] create a new user in a group | Sferacarta Software | 13:35 |
| Re: [SQL] How to Make Case InSensitive??? | Barracuda | 13:48 |
| Re[2]: [SQL] How to Make Case InSensitive??? | Sferacarta Software | 14:14 |
| Re[2]: [SQL] How to Make Case InSensitive??? | Herouth Maoz | 14:42 |
| Re: [SQL] How to Make Case InSensitive??? | Bruce Momjian | 17:30 |
| rtree, btree, hash index methods...should I care? | Patrick Giagnocavo | 18:19 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] How to Make Case InSensitive??? | Jerome Knobl | 08:13 |
| Datetime field | Henrik Denseje Pedersen | 10:46 |
| Re: [SQL] Datetime field | Jose' Soares | 13:28 |
| Turn autocommit off ? | Andreas Joppich | 14:12 |
| Re: [SQL] Turn autocommit off ? | Federico Passaro | 14:46 |
| IF..THEN..ELSE | David J. Haglin | 15:46 |
| Re: [SQL] Turn autocommit off ? | Bruce Momjian | 16:00 |
| Re: [SQL] Turn autocommit off ? | Bruce Momjian | 16:02 |
| Thread | Author | Time |
|---|---|---|
| postmaster dies on complicated views | David Rugge | 02:14 |
| Re: [SQL] postmaster dies on complicated views | Bruce Momjian | 02:58 |
| PostgreSQL syntax question | Stephen Davies | 05:07 |
| SQL equiv to MS-Access Transform | William Leeke | 06:39 |
| Re: [SQL] SQL equiv to MS-Access Transform | David Hartwig | 12:47 |
| Re: [SQL] PostgreSQL syntax question | Sferacarta Software | 13:13 |
| Re: [SQL] PostgreSQL syntax question | Bruce Momjian | 16:21 |
| Re: [SQL] Turn autocommit off ? | Peter T Mount | 17:29 |
| Thread | Author | Time |
|---|---|---|
| date problem | Ian Johnston | 21:53 |
| Re: [SQL] How to Make Case InSensitive??? | Leslie Mikesell | 22:48 |
| To create the query for a select where one is NOT in the other | Karl Denninger | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] To create the query for a select where one is NOT in the other | Eric McKeown | 23:23 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] How to Make Case InSensitive??? | Bruce Momjian | 01:39 |
| Q:Update Rule | Detlef Boddin S/N O.21 | 10:00 |
| Re: [SQL] Q:Update Rule | Sferacarta Software | 13:53 |
| subscribe sql | Deslippe, Michael | 17:56 |
| RE: [SQL] To create the query for a select where one is NOT in th e other | Jackson, DeJuan | 18:07 |
| Re: [SQL] How to Make Case InSensitive??? | Mirek Budzanowski | 19:07 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] How to Make Case InSensitive??? | Bruce Momjian | 16:47 |
| 2 questions. | Colin Dick | 17:01 |
| Question re: null | Colin Dick | 17:37 |
| case-insensitive SORT BY? | Patrick Giagnocavo | 19:53 |
| Selecting from float4[] arrays | G. Anthony Reina | 20:09 |
| create function syntax question | William Leeke | 20:30 |
| Where to find postgres and SQL examples?? | William Leeke | 20:34 |
| RE: [SQL] To create the query for a select where one is NOT in th e other | Eric McKeown | 20:49 |
| Re: [SQL] case-insensitive SORT BY? | Richard Lynch | 21:41 |
| RE: [SQL] To create the query for a select where one is NOT in th e other | Jackson, DeJuan | 23:09 |
| arrays | Brook Milligan | 23:40 |
| Thread | Author | Time |
|---|---|---|
| subscribe | Lotto | 12:13 |
| Re: [SQL] 2 questions. | Chris Johnson | 12:44 |
| Re: [SQL] case-insensitive SORT BY? | Chris Johnson | 12:47 |
| Re: [SQL] 2 questions. | Sferacarta Software | 13:45 |
| Re: [SQL] Question re: null | Sferacarta Software | 15:25 |
| Cursors | Glenn Sullivan | 15:55 |
| '' != NULL in PostGres??? | Neil Harkins | 17:41 |
| Re: [SQL] '' != NULL in PostGres??? | Brook Milligan | 18:10 |
| Re: [SQL] case-insensitive SORT BY? | David Hartwig | 18:31 |
| Re: [SQL] '' != NULL in PostGres??? | Colin Dick | 18:57 |
| Re: [SQL] Cursors | Richard Lynch | 20:09 |
| Re: [SQL] '' != NULL in PostGres??? | James Olin Oden | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] Re: [SQL] 2 questions. | Thomas G. Lockhart | 02:34 |
| Hello everybody,some question! | Tong Hoai Dan | 02:42 |
| Re: [HACKERS] Re: [SQL] 2 questions. | Jose' Soares | 10:46 |
| Re: [HACKERS] Re: [SQL] 2 questions. | Thomas G. Lockhart | 13:50 |
| C compiler error when using PostGres | G. Anthony Reina | 20:30 |
| Re: [SQL] C compiler error when using PostGres | John E. Garrott | 20:47 |
| Re: [SQL] C compiler error when using PostGres | G. Anthony Reina | 21:21 |
| I can't seem to set the -B option on the postmaster over 3000 | G. Anthony Reina | 22:22 |
| Thread | Author | Time |
|---|---|---|
| Having trouble with join | G. Anthony Reina | 00:49 |
| Re: [SQL] C compiler error when using PostGres | James Olin Oden | 11:44 |
| Thread | Author | Time |
|---|---|---|
| Problems with inserting into tables... | Gemeinschaft Studienarbeit Datenbanken | 15:55 |
| Thread | Author | Time |
|---|---|---|
| Timespan conversion | Herouth Maoz | 12:53 |
| Another nut to crack with insertion into tables... *sigh* | Gemeinschaft Studienarbeit Datenbanken | 20:46 |
| Thread | Author | Time |
|---|---|---|
| subscribe | Stan Thomas | 07:08 |
| SQL type conversion - text to char/varchar | R.K.Street | 09:48 |
| Re: [SQL] Another nut to crack with insertion into tables... *sigh* | Sferacarta Software | 13:35 |
| Re: Another nut to crack with insertion into tables... *sigh* | Tom Lane | 14:02 |
| Setting current time on insert | Bryan White | 14:50 |
| Re: [SQL] Re: Another nut to crack with insertion into tables... *sigh* | Herouth Maoz | 16:20 |
| Thread | Author | Time |
|---|---|---|
| Getting datatype before SELECT | Glenn Sullivan | 17:05 |
| Re: [SQL] Getting datatype before SELECT | David Hartwig | 21:28 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Getting datatype before SELECT | D'Arcy J.M. Cain | 02:10 |
| Re: [SQL] Getting datatype before SELECT | Bob Smither | 02:30 |
| Re: [SQL] Getting datatype before SELECT | James Olin Oden | 11:40 |
| Re: [SQL] Getting datatype before SELECT | Bryan White | 13:19 |
| Re: [SQL] Getting datatype before SELECT | herouth maoz | 22:21 |