[I asked this question on the "interfaces" list, but nobody answered ...]
Suppose that I have created a LOB, written a bunch of data to it, and
committed.
Is it now possible to rewrite the LOB to contain a lesser amount of data?
In other words can I do the equivalent of UNIX open(..., O_WRONLY
Greetings,
I am having difficulty creating a way to insert into a view which joins
multiple tables (specifically a view which joins multiple records from a
single table to a record in another table).
Please see the enclosed simple example for how I am currently inserting
(updating, etc.) on view
Hi,
I would like to know what is the easiest way to add multiple difference of
datetime but show the result in hour and minute something like :
table foo:
start datetime
end datetime
I would like to do :
select sum(end-start) from foo;
but it gives me 3 days 12 hours 23 minutes...etc
I wo
> CONSTRAINT TYPE_CD_OK CHECK (
> EXISTS (SELECT 1 FROM XREF WHERE
> XREF_GROUP = 'CUST_TYPE' AND
> XREF_CD = TYPE_CD)
> )
>
>
> > There seems to be more serious problems.
> > 1) The constraint is not only for the defined table but also for
referenced
> > tables in the subquery.
>
> I don't un
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Niall Smart
>
>
> CONSTRAINT TYPE_CD_OK CHECK (
> EXISTS (SELECT 1 FROM XREF WHERE
> XREF_GROUP = 'CUST_TYPE' AND
> XREF_CD = TYPE_CD)
> )
>
>
> >
Hi.
Im trying to implement a referential integrity check that I suspect there
is a much better way to do that what I have done. Basically what I have is
a "order" table and a "order items" table. I would like to make it so that
if all items are removed from the order, then the corresponding "or
Hi,
Don't know if it's possible, but how do I make the following SQL
statments right?
table
---
name int4
attribute text[]
select attribute[1]
from table
case when attribute[1]='yes'
then select attribute[2] from table
else select attribute[3] from table;
Basically, I want to c
Niall Smart <[EMAIL PROTECTED]> writes:
> Does anyone know if this is on the radar for 7.1?
7.2 ...
regards, tom lane
Michael Ansley wrote:
>
> Would there be a particular reason to do this?
>
I like to define views for lookups (i.e. job titles,
departments, accounts, whatever). It would be nice
if I could just do a select * from whatever_vw instead
of having to remember to put the order by whatever_name
cla
Title: RE: [SQL] ORDER BY in definition of views
Would there be a particular reason to do this?
MikeA
>> -Original Message-
>> From: Niall Smart [mailto:[EMAIL PROTECTED]]
>> Sent: 08 June 2000 14:47
>> To: [EMAIL PROTECTED]
>> Subject: [SQL] ORDER BY in definition of vi
Guys,
Does anyone know if this is on the radar for 7.1?
Niall
--
Niall Smart
email: [EMAIL PROTECTED]
phone: (087) 8052390
Michael Fork wrote:
> CREATE INDEX idx_radacct_1 ON radacct (username,acctstatustype,tstamp);
> CREATE INDEX idx_radacct_2 ON radacct (username,acctstatustype);
> CREATE INDEX idx_radacct_3 ON radacct (username,tstamp);
> CREATE INDEX idx_radacct_4 ON radacct (acctstatustype,tstamp);
> CREATE INDE
CONSTRAINT TYPE_CD_OK CHECK (
EXISTS (SELECT 1 FROM XREF WHERE
XREF_GROUP = 'CUST_TYPE' AND
XREF_CD = TYPE_CD)
)
> There seems to be more serious problems.
> 1) The constraint is not only for the defined table but also for referenced
>
$row = pg_fetch_array($exec, 1);
echo $row['col2'];
Regards
Omid Omoomi
>From: Bernie Huang <[EMAIL PROTECTED]>
>To: PGSQL-SQL <[EMAIL PROTECTED]>
>Subject: [SQL] Fetch an element in an array
>Date: Wed, 07 Jun 2000 17:21:52 -0700
>
>Hi,
>
>This is more of a PHP problem, but I wish if someone k
14 matches
Mail list logo
