Philip Molter <[EMAIL PROTECTED]> writes:
> Is there anything I should specifically be looking for?
The only guess I have at the moment is that maybe the stacommonval
(most common value) of the 'deleted' or 'running' column matches the
query in one state and not the other. But please, just send
On Thu, Jul 05, 2001 at 12:05:52PM -0400, Tom Lane wrote:
: Hmm. Nothing out of the ordinary about the table schemas. The relevant
: bits of the query seem to be
:
: > FROM percept p
: > INNER JOIN perceptType pt ON pt.ptid=p.ptid
: >AND pt.runinterval IS NO
On Thu, 5 Jul 2001, eddie iannuccelli wrote:
> Regrading your discussion, at the end, what is the difference between a
> REFERENCE clause in a field definition and a FOREIGN KEY in the table
> definition ? What is the best solution to implement a classical foreign
> key in a table ?
"If a i
Hmm. Nothing out of the ordinary about the table schemas. The relevant
bits of the query seem to be
> FROM percept p
> INNER JOIN perceptType pt ON pt.ptid=p.ptid
>AND pt.runinterval IS NOT NULL
>WHERE p.deleted=0 AND UNIX_TIMESTAMP( p.nextrun )<=NO
Can you create a function (CREATE FUNCTION) that
does not return any value?
---Daniel Åkerud
[ Don't underestimate the power of stupid people in
large groups]
Check out http://www.postgresql.org/idocs/index.php?sql-comment.html.
I got my knowledge from the PostgreSQL: Introduction and Concepts book.
HTH,
Colin
> -Original Message-
> From: omid omoomi [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 05 July 2001 14:22
> To: [EMAIL PROTECTED]; [EMAIL
You could use the "COMMENT" command.
Something like:
COMMENT ON TABLE IS '';
HTH,
Colin
> -Original Message-
> From: Fariba Noorbakhsh [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 04 July 2001 14:54
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Table Description!!
>
>
> Hi everybody,
