Re: [GENERAL] Inserting CR/LF in a select?
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 Olbersen iGuard Engineer St. Bernard Software 11415 West Bernardo Court San Diego, CA 92127 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] move to usenet?
> -Original Message- > From: David W Noon [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 19, 2003 4:20 AM > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] move to usenet? > > I agree that many messages are not formatted according to Usenet > conventions, but I normally attribute that to Windows users who know > nothing about the Internet. Thus, top-posting and > full-quoting are rife all > across Usenet. David, What is the point of bottom posting anymore? I thought it had to do with turn-around time so that you could re-read whatever it is you wrote a "long time ago". I highly doubt you would know, but is there an easy way to make Outlook 2000 (not Express) bottom post? I've searched groups.google.com for it and found only things like "Copy & paste your signature", etc. Full-quoting is just a pain when it 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
Culley, > But on my production machine postgresql complained about the order by > clause-- it wanted the table alias to be on last_name. I believe this is because you used "u.last_name" earlier in the statement, and the ORDER BY clause doesn't know that's what you 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: culley harrelson [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 10:48 AM > To: [EMAIL PROTECTED] > Subject: [GENERAL] 7.3.3 behaving differently on OS X 10.2.6 > and FreeBSD > 4.8-STABLE > > > I don't know if this is a postgresql bug or a problem with my > architecture but I thought I would post here about a strange > bug I just > came across in my application. > > I use OS X 10.2.6 as my development machine and FreeBSD 4.8 for my > production machines. All systems are running postgresql > 7.3.3. I just > published some code to production and when testing the production > results it blew up with a sql parsing error. The following > sql worked > fine on my OS X development machine: > > select u.user_id, u.first_name, u.last_name, u.email_address, w.w9, > pm.description as payment_method, count(s.user_id) as documents, > sum(s.payment_amount) as amt_sum from ht_user u inner join > writer w on > u.user_id = w.user_id inner join payment_method pm on > w.payment_method_id = pm.payment_method_id left join submission s on > u.user_id = s.user_id group by u.user_id, u.first_name, u.last_name, > u.email_address, w.w9, pm.description order by lower(last_name) asc > > But on my production machine postgresql complained about the order by > clause-- it wanted the table alias to be on last_name. > > culley > > > > ---(end of > broadcast)--- > TIP 7: don't forget to increase your free space map settings > ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Database geeks
Perhaps this is a result of the cost of failure? What I mean to say is that very often database apps have to deal with *huge* volumes of data. As such, you could end up wasting *hours* if your app doesn't work correctly. With PHP dev, for the most part, you refresh your browser to test. 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] > Sent: Friday, June 20, 2003 3:51 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Database geeks > > > One thing I've noticed about this group versus the php group; > You guys don't work 16 hours a day, or live, each, and s**t > this subject, like the PHP guys do. > > I make the assumption that most of you are more mature, > steady eddie types who do throrough planning in your projects > and have less emergencies during there rest of the night. > Also, perhaps, being one layer removed from the customer > interface means less complex UI problems to get hammered on > day and night, and therefore less to go wrong and less > opportuntity for it to go wrong. > > > ---(end of > broadcast)--- > TIP 7: don't forget to increase your free space map settings > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html