Re: [SQL] C/C++ interface

2001-02-15 Thread Volker Paul
Tom Lane wrote: > > Volker Paul <[EMAIL PROTECTED]> writes: > > Is someone maintaining the C++ interface and its documentation? > > Not really. Feel free to step up and lend a hand ... I found some functions of the C++ binding library that are not or scarcely documented, namely: int GetIsNul

[SQL] Re: [ADMIN] TPCH questions

2001-02-15 Thread Peter Eisentraut
Victor Muntes Mutero writes: > select * from (select * from supplier); (for example) No subselects in FROM before 7.1. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [SQL] problem with casting

2001-02-15 Thread Josh Berkus
Ted, > responce: can not cast type 'date' to 'text' > > Did i miss-read this section. I thought I could cast the date to text. has anyone >seen > this or am I missreading the docs? 'fraid so. You cannot cast Date as Text, because (presumably) the DB engine doesn't know how you want to form

Re: [SQL] cannot create sequence

2001-02-15 Thread Tom Lane
Olaf Zanger <[EMAIL PROTECTED]> writes: > good guess, they are still there. > can i just delete them? Yes, if there's not any corresponding system-catalog entry for them. regards, tom lane

Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
um, sorry, forgot to ask then this is a bug eh :-¦ ? olaf Tom Lane schrieb: > > Olaf Zanger <[EMAIL PROTECTED]> writes: > > it doesn't show ver_id_seq, nor own_id_seq when doing a \ds > > but it brings up an error "cannot create sequence) if i want to > > create table ver (id serial, ...); >

Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
hi there, good guess, they are still there. can i just delete them? olaf Tom Lane schrieb: > > Olaf Zanger <[EMAIL PROTECTED]> writes: > > it doesn't show ver_id_seq, nor own_id_seq when doing a \ds > > but it brings up an error "cannot create sequence) if i want to > > create table ver (id s