Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19932; Thu, 28 May 92 14:22:42 -0700
Message-Id: <9205282122.AA19932@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: string comparison
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Thu, 28 May 92 14:10:24 PST.
             <9205282110.AA19435@postgres.Berkeley.EDU> 
Date: Thu, 28 May 92 14:26:19 PDT

In message <9205282110.AA19435@postgres.Berkeley.EDU> you write:
> 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 c
  +haracters, 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

say

	create foo (a = text)

	append foo (a = "this is a text string")
	retrieve (foo.all) where foo.a = "this is a text string"

see the reference manual if you need more examples.

					mike olson
					postgres research group
					uc berkeley
					mao@cs.berkeley.edu