[GENERAL] How to select using LIKE with bytea?
First a row, then the question. archives=# select * from archives; listname | received_date | header_date | subject | author | | headers | | body --+++--++---+--- admin| 2001-09-03 22:37:19-04 | 2001-09-03 15:24:29-04 | Need Web | [EMAIL PROTECTED] | From [EMAIL PROTECTED] Mon Sep 3 11:40:22 2001\015\012Received: from CheapWebPager.com Newsletter\015\012Date: Mon, 03 Sep 01 14:24:29 EST\015\012From: [EMAIL PROTECTED]\015\012To: [EMAIL PROTECTED]\015\012Subject: Need Web\015\012 | This is test text. a\\'one\\'b\012more test text. left slash , right slash /.\012let\\'s embed a (\\\000\\\000) NULL. This should not break things.\012--no more--\012-d\012 (1 row) archives=# select * from archives where headers like '%To: webmaster%'; ERROR: Unable to identify an operator '~~' for types 'bytea' and 'unknown' You will have to retype this query using an explicit cast How should I be writing this so as to match rows where the headers include 'To: webmaster'? David ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[GENERAL] is there a function/variable with remote host addr?
As the subject says, is there a function or variable in pg I can use as a default insert/update value on a column that represents the IP or hostname of the current session's remote client? David ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] speed of communication and pgsql development
Bruce Momjian wrote: We are on #postgresql on Efnet. Have been for years, and mentioned in the FAQ. Very good for getting development help. I was working with the PAM patch author there today. Ugg. I'd rather setup a bot to relay to irc.openprojects.net. EFnet is a sickly beast that can't manage to keep links and routing worth a darn. Not to mention that several servers can't seem to figure out your hostname or ident even tho tcpdump clearly shows the response. 'twould only be EFnet servers that do this. -d -- : I may have the information you need and I may choose only HTML. It's up to you. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)
Sean Chittenden wrote: Has anyone seen this page on Mysql.org comparing PostgreSQL to MySQL: http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html Yeah, I've had a few developers show it to me... the best part of this is though, when I tried to post a comment, I got a MySQL database error. ::grin:: At anyrate, it looks like a load of FUD from a bad marketing department (at least Microsoft lies well). -sc One might also add as a 'con' for mysql...spelling. As horribly frequent the spelling errors are on this page, one might reasonable assume that you could... selected * frm tabloid wear valued be 'huh?'; -d -- : I may have the information you need and I may choose only HTML. It's up to you. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[GENERAL] A lock to fit a key..
I need to figure out a way to allow users to only be able to update a certain column in a table. Does anyone have any ideas to start with? David ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster