or near ","
Trying to run a query like, 'select position(email, ',') from table'
fails with the same parse error, however 'select strpos(email, ',') from
table' runs fine...
any hints?
--
|-|-
else (i found strpos() but i'm not sure if
that does exactly the same thing).
--
|-|----|
| Hitesh Patel| Voice: (541) 759-3126 |
| | Fax: (541) 759-3214 |
| Pref
Does anyone have a function laying around that convert a 'money' type to
a float8 and return it?
CA';
returns
ERROR: No such function 'float8' with the specified attributes
And again i'm stuck :-)
Thanks in advance for any help.
--
|-----|--------|
| Hitesh Patel| Voice: (541) 759-
I have a table with a filed named 'amount' and all the values are
positive values, but if i do this:
select sum(amount) from table where state = 'CA';
I get a negative number. Doing a
select name, amount from table where state = 'CA' and amount < '0';
Returns 0 rows.
ing
going to postgres. I believe the patch there is sufficient, i have made
a lot of custom tweaks and maybe after cleaning things up will release
it to the tigers :-)
http://www.miquels.cistron.nl/radius/
--
|-----||
| Hitesh Patel
I have a table with and email address and a datetime timestamp. What
would be the easiest way to select the 3 earliest timestamps (earliest
being furthest in the past from the current date)
