Don't drive yourself crazy ( like me ;). You'll have to write some
procedural code - sorry. I believe IBM's DB/2 supports recursive
queries as defined by SQL3. Oracle provide a couple of non SQL standard
clauses (CONNECT BY, LEVELS) to provide similar funcionality.
-Ron-
GPG and other info at:
Hello!
just trying to write an upgrade script for my bookkeeping system and
noticed that it seems that i can't throw out the legacy stuff
accumulated over time
as far as i can tell, i can add columns to a table, but can't remove
them later on.
is this true? any easy way to circumv
=?KOI8-R?B?IuzP19DB3sUg4crEwc3J0iI=?= <[EMAIL PROTECTED]> writes:
> create function get_fio1(text) returns varchar
> as 'select fio from patient_temp where fio like $1::text || \'%\';'
> language 'sql';
You won't get an indexscan for this because the LIKE pattern is not
a constant at planning t
"Michael Richards" <[EMAIL PROTECTED]> writes:
> [ a severely incomplete problem description ]
Table schema? Full text of the query?
> It has one index defined on:
> Index "formdata_pkey"
> Attribute | Type
> ---+-
> formid| integer
> occid | integer
> userid
"Chris Ruprecht" <[EMAIL PROTECTED]> writes:
> phone=# select * from phonelog where cdate > 2001-05-18 order by cdate limit
> 2 ;
Try
select * from phonelog where cdate > '2001-05-18' order by cdate limit 2
I think it's interpreting your query as where cdate > 1978 (result of
integer subexpress
I'm not sure, but...
Does it work if you say cdate > '2001-05-18' ? (Possibly ::date too)
I'd guess your date value you're trying to put there is getting treated
as an integer expression.
On Wed, 23 May 2001, Chris Ruprecht wrote:
> Hi all,
>
> although not new to databases, I'm new to the wo
On Wed, 23 May 2001, Michael Richards wrote:
> Finally, I'm planning on moving this to 7.2 and converting all the
> joins to use outer joins. Will there be a significant penalty in
> performance running outer joins?
Why are you planning on using outer joins? Yes there is a performance penalty
be
Hi all,
although not new to databases, I'm new to the wonderful world of PostGreSQl
and SQL in general.
Question:
I do this query
phone=# select * from phonelog where cdate > 2001-05-18 order by cdate limit
2 ;
And I get theis result
cdate| ctime | countrycode | success | carrier | dura
Hi all!
Anyone know if it's possible to make a recursive select from a table ?
My problem: I got a table of "some categories" which all points to its
parrent one(tree)...shown below. And I want to select all names of
parrent categories of one child, lets say "fast[4]". Now I'm solving that
with
m
