Re: [GENERAL] Inserting CR/LF in a select?

2003-08-22 Thread David Olbersen
Bjørn T Johansen muttered: > I need to get two fields from two tables and append them into one field > with CR/LF in between, how is this done using a select? I believe something along the lines of: SELECT column1||'\r\n'||column1 FROM table; will do the trick. -- David

Re: [GENERAL] move to usenet?

2003-08-20 Thread David Olbersen
comes to searching on google, since a reply may only consist of quoted messages and then a "read the whole message" link. -- David Olbersen iGuard Engineer St. Bernard Software ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] 7.3.3 behaving differently on OS X 10.2.6 and FreeBSD 4.8-STABLE

2003-08-09 Thread David Olbersen
mean. That's a guess that doesn't really explain why it'd work under one OS and not under another. Are the two versions of Postgres configured the same? -- David Olbersen iGuard Engineer St. Bernard Software > -Original Message- > From: cu

Re: [GENERAL] Database geeks

2003-06-20 Thread David Olbersen
If it doesn't work right you make a quick change and you're off. My $0.02 -- David Olbersen iGuard Engineer 11415 West Bernardo Court San Diego, CA 92127 1-858-676-2277 x2152 > -Original Message- > From: Dennis Gearon [mailto:[EMAIL PROTECTED] &g