You can try
If (IsNumeric(varToTest) And 0 = CDbl(varToTest)) Then IsNothing = True
Bret wrote:
This may not be the right group, if so, just let me know.
I have a table with a type [numeric].
When executing queries, I get the data which happens to
be (6.5) in this case, but my VB6 function w
On 27/01/2005 01:06 phil campaigne wrote:
Hi All,
I have a double type in java that I am trying to store in postgresql as
type numeric and it doesn't seem to like it. The error message is,
function double(numeric) does not exist
unable to identify a function that satisfies the given argument type
First, every type in postgres is user-defined, in the sense that its
binary structure and the arithmetic and comparison operations you can
perform on it are defined by a set of native C functions that are
present in the database executable or loaded as shared libraries.
Because of postgres's e
This is a very interesting option. My biggest concern is performance:
the project will require tables with millions of tuples. How does the
performance of such user created types compare to using native types? Or
are they 'built' using the same structure?
Thanks again!
Marc
Paul Tillotson wrote
Use a numeric type if you need more precision.
template1=# create domain BIGINT_UNSIGNED numeric(20,0) check (value >=
0 and value < '18446744073709551616'::numeric(20,0));
CREATE DOMAIN
template1=# create table foobar (i BIGINT_UNSIGNED);
CREATE TABLE
template1=# insert into foobar (i) values (-1
From: "Shahab Asgharzadeh" <[EMAIL PROTECTED]>
> Access will write the sql as:
> delete from "tablename" where "col1" = 1234 AND "col2" = 'text' AND "col3"
=
> 100.200
>
> ERROR: Unable to identify an operator '=' for types 'numeric' and
'float8'
> You will have to retype this query usin
