Re: [SQL] '13 months ago'::reltime

2001-05-05 Thread Peter Eisentraut
Christopher Sawtell writes: > On Friday 04 May 2001 06:32, you wrote: > > Type reltime is old and deprecated. Don't use it. > > What should we be using instead? interval -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)

Re: [SQL] Dateadd

2001-05-05 Thread Josh Berkus
Folks, FYI - this difference in syntax is because PostgreSQL implements real SQL operators (i.e. what the operator does and what arguments it takes depend on the data types involved) and Microsoft does not (in MS SQL, operators mean the same thing for almost all data types). Spea

[SQL] Need help with search-and-replace

2001-05-05 Thread Josh Berkus
Folks, I need to strip certain columns out of my pgdump file. However, I can't figure out how to use any Unix-based tool to search-and-replace a specific value which includes a tab character (e.g. replace "{TAB}7 00:00:00" with "" to eliminate the column). RIght now, I'm copying

Re: [SQL] Dateadd

2001-05-05 Thread Tom Lane
"Josh Berkus" <[EMAIL PROTECTED]> writes: > Speaking of which, why doesn't PostgreSQL allow the use of "+" between > two VARCHARs to mean the same as "||" ? You mean, other than the fact that "||" is the SQL-standard string concatenation operator and "+" isn't? I'm not eager to follow the pied p