agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedpostquel data type
4+ messages / 4 participants
[nested] [flat]
* postquel data type
@ 1993-02-18 18:38 Li Lin <huang%saturn@sdsu.edu>
0 siblings, 0 replies; 4+ messages in thread
From: huang%saturn@sdsu.edu @ 1993-02-18 18:38 UTC (permalink / raw)
To: postgres@postgres.berkeley.edu
Dear POSTGRES group,
Does the released POSTGRES support postquel as data type?
Why did I get error from :
create E (name=postquel) \g
Thank you
Li Lin Huan
^ permalink raw reply [nested|flat] 4+ messages in thread
* postquel data type
@ 1993-06-08 11:13 M92 <hamiltop@computer-science.manchester.ac.uk>
0 siblings, 0 replies; 4+ messages in thread
From: M92 @ 1993-06-08 11:13 UTC (permalink / raw)
To: postgres@postgres.berkeley.edu
I`m attempting to create a class where two of the attributes are composite
types. I'm defining these attributes to be of the procedure-type postquel. I'm
then hoping to be able to append postquel queries as instances attributes. A
method outlined by Stonebraker and Rowe in the papers The Design of Postgres and
The Postgres Data Model.
However when I issue the command to create the class :
* create OBJECT (name = char16, source = postquel, object = postquel) \g
I'm returned the meesage :
Query sent to backend is "create OBJECT (name = char16, source = postquel, object = postquel) "
WARN:Jun 8 11:43:36:parser: syntax error at or near "postquel"
Can anyone tell me where I'm going wrong ?
Paul.
^ permalink raw reply [nested|flat] 4+ messages in thread
* postquel data type
@ 1993-06-08 23:39 Caroline M. Paxson <paxson@postgres.Berkeley.EDU>
0 siblings, 0 replies; 4+ messages in thread
From: Caroline M. Paxson @ 1993-06-08 23:39 UTC (permalink / raw)
To: postgres@postgres.berkeley.edu
Hi,
The problem with the following:
* create OBJECT (name = char16, source = postquel, object = postquel) \g
Query sent to backend is "create OBJECT (name = char16, source = postquel, object = postquel) "
WARN:Jun 8 11:43:36:parser: syntax error at or near "postquel"
is that the type "postquel" is not supported. Take a look at the
list of supported types in the Introduction(Built-ins) section of
the Postgres manual. (I'm assuming you haven't defined your own
type called postquel.)
I am currently working on implementing Postgres sets in a way which
will allow you to store queries as sets. In the meantime, you might
try using functions, i.e. instead of having an attribute "source", define
a Postquel function called "source".
Carol Paxson
paxson@cs.berkeley.edu
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postquel data type
@ 1993-06-09 16:38 avi@postgres.berkeley.edu
0 siblings, 0 replies; 4+ messages in thread
From: avi@postgres.berkeley.edu @ 1993-06-09 16:38 UTC (permalink / raw)
To: postgres@postgres.berkeley.edu
> The problem with the following:
>
> * create OBJECT (name = char16, source = postquel, object = postquel) \g
>
> Query sent to backend is "create OBJECT (name = char16, source = postquel, object = postquel) "
> WARN:Jun 8 11:43:36:parser: syntax error at or near "postquel"
>
>
> is that the type "postquel" is not supported.
In addition, postquel is a reserved word, which is why you get the error
message you see rather than "type name lookup of postquel failed". You
will have to use some other name for your type.
avi
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1993-06-09 16:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1993-02-18 18:38 postquel data type Li Lin <huang%saturn@sdsu.edu>
1993-06-08 11:13 postquel data type M92 <hamiltop@computer-science.manchester.ac.uk>
1993-06-08 23:39 postquel data type Caroline M. Paxson <paxson@postgres.Berkeley.EDU>
1993-06-09 16:38 Re: postquel data type avi@postgres.berkeley.edu
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox