Gary WAN wrote:
> I would like to ask if there is any SQL command to replace "CREATE
> ASSERTION" in Postgresql since ASSERTION is not supported by
> postgresql. Thank you.
There is not, but this is the wrong list to be asking this.
---(end of broadcast)
Philipp Matthias Hahn wrote:
> # SELECT round(5.5::float4),round(50.5::float4);
> round | round
> ---+---
> 6 |50
> (1 row)
>
> I think this is a bug, since I would expect 6 and 51.
The default rounding mode for floating point (determined by your C
library, mostly) it to round
"Daniel O'Neill" <[EMAIL PROTECTED]> writes:
> Hmm, the design isn't very 'pick aparty', would it be kosher of me to send you the
> full schema to work with? I can email it directly.
Sure, a pg_dump -s dump would be fine. If it's large you can just send
to me off-list.
It's possible that this
On Fri, 27 Feb 2004 00:57:36 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Daniel O'Neill" <[EMAIL PROTECTED]> writes:
> > Anyway, here's the vitals, including our layout:
>
> Could I trouble you to provide those table and view definitions as an
> SQL script? (pg_dump -s will help you.) I'm too
Dear Sir,
I would like to ask if there is any SQL command to replace "CREATE
ASSERTION" in Postgresql since ASSERTION is not supported by postgresql.
Thank you.
Best Regards,
Gary Wan
_
Linguaphone : Learning English? Get Japanese
Section 8.1 of the manual gives the range of an integer
as -2147483648 to +2147483647.
template1=# select '-2147483648'::int;
int4
-
-2147483648
(1 row)
template1=# select -2147483648::int;
ERROR: integer out of range
Oops.
template1=# select version();
Hello!
# SELECT round(5.5::float4),round(50.5::float4);
round | round
---+---
6 |50
(1 row)
I think this is a bug, since I would expect 6 and 51. Doing the same
without the float4-cast, it works correct. This bug bites me while
passing parameters to a plpgsql function.
This ha
Following cursor declaration which worked in 7.3.4, produces
a seg fault with 7.4.1 and todays cvs.
exec sql
declare functestcur0 scroll cursor for
select oid, * into
:rownum
,:sfunckey
,:sfuncfill
exec sql begin declare section;
static int intcur[50][10] = { 0 };
produces :
ERROR: No multi-dimensional array support for simple data types
Margit
---(end of broadcast)---
TIP 6: Have you searched our list archives?
ht
