Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19435; Thu, 28 May 92 14:10:24 -0700
Date: Thu, 28 May 92 14:10:24 -0700
Message-Id: <9205282110.AA19435@postgres.Berkeley.EDU>
From: sud@philabs.Philips.Com  (Sudheer R. Vangati)
Subject: string comparison
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Cc: mummy!sud@uunet.UU.NET

Hi!
	Could any one give me some information on string comparison in postgres?
I was hoping to avoid character arrays altogether and instead use string of characters, since postgres does not allow comparisons of character arrays.

eg:

create PROJECT (APPLICATION=char[], TYPE=char[], NO_OF_LICENCES=int4)\g
append PROJECT (APPLICATION="Frame Maker", TYPE="Publishing", 
NO_OF_LICENCES=5)\g

This does not work....

replace PROJECT (NO_OF_LICENCES=9) where PROJECT.APPLICATION="Frame Maker"\g
 
Query sent to backend is "replace PROJECT (NO_OF_LICENCES=9) where PROJECT.APPLICATION="Frame Maker""
WARN:May 28 15:32:32:OperatorDef: no operator =

This works....

replace PROJECT (APPLICATION="Word Perfect") where PROJECT.NO_OF_LICENCES=9\g

Query sent to backend is "replace PROJECT (APPLICATION="Word Perfect") where PROJECT.NO_OF_LICENCES=9"
REPLACE
why is it so?

Is there anyone out there who has already thought of and may be written the type stringcmp??

Any info will be of great help. thanx in advance.