You should use some variation of overlaps or
contains within. There is some discussion and
a list of operators in Issue #61 of General Bits.
( http://www.varlena.com/GeneralBits/61 )
I would also suggest looking at the geometric
operators in the documentation. You may have
to cast the polygon to
> Is it possible to create a database function that mimics the C function atof?
> I'm guessing it should look something like this:
You can do this to convert a string to a float:
select '3.14'::float + 1;
?column?
--
4.14
(1 row)
Is that what you want?
Yasir
--
Hello,
I've got a table in an oracle database with approx. 10 records, that
I'd like to put into a table in a postgresql database. (This should be
done a couple of times per week)
I have written a short perl script, on a server that has remote access
to both the oracle database as well as t
Hello,
Is it possible to create a database function that mimics the C function atof?
I'm guessing it should look something like this:
create function atof(varchar) returns float
as '??'
language
returns null on null input;
Thanks,
Mark
-
Hi,
I've a strange bug on PgSQL 7.3.3 with function, constraints and
transactions.
As the foreign key are too heavy for a massive insert, even set defered,
we've decided to put them in a function in order to enable/disable them.
So, in such a transaction, first we disable the constraints, using
On Fri, 20 Feb 2004, Silke Trissl wrote:
> Hi,
>
> I have an application where users can enter the date via a web interface.
>
> Recently I upgrated my PostgreSQL version from 7.3 to 7.4.1.
>
> On 7.3 I run several tests about the format of the date and found,
> that Postgres accepts almost eve
Silke Trissl <[EMAIL PROTECTED]> writes:
> On 7.3 I run several tests about the format of the date and found,
> that Postgres accepts almost everything. Today I found out, that 7.4.1
> only accepts dates in the format mm-dd-yy,
It now requires the field order to be what DateStyle says it is. See
Folks,
Is there a catalog table or location where I can go to find data counts for
tables?
It would be nice if I could do a query which returned something like:
table_name#Rows
cust 1000
order 5000
order_detail 9500
without having to have the overhead of querying each tabl
On Thursday 19 February 2004 19:26, Josh Berkus wrote:
> Rodrigo,
>
> > I insist in my question, is there a way to compile the plpgsql codes or
>
> something like that, or its better to think about writting this postgres
> functions in C??
>
> No, there is not. Nor is there likely to be for
