Uz.ytkownik cio198 napisa?:
Hello,
i've created this table
CREATE TABLE "budget" (
"year" character varying NOT NULL,
"month" character varying NOT NULL,
"accountno" character varying NOT NULL,
"costid" character varying NOT NULL,
"valutacode" character va
[EMAIL PROTECTED] (cio198) writes:
> The problem is the numeric data in the view isn't limited to
> numeric(9,2) instead it become numeric(65535, 65531).
It should look like plain, unrestricted "numeric". Whatever is showing
you those bogus precision/scale fields is wrong. What client software
a
On Mon, Mar 31, 2003 at 11:08:48 +0530,
Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote:
>
> I am wanting to make an application similar to you
> which shud be able to get all the places within certaint
> radius of the place in question.
If you look at contrib/earthdistance in the 7.4 source
Hello,
i've created this table
CREATE TABLE "budget" (
"year" character varying NOT NULL,
"month" character varying NOT NULL,
"accountno" character varying NOT NULL,
"costid" character varying NOT NULL,
"valutacode" character varying,
"budgetvalue"
Josh Berkus wrote:
>
> Andreas,
>
> > 1) update test set a=0 -> trigger does its work
> > 2) update test set a=0, b=1, c=2 -> trigger does nothing
> > 3) update test set a=0, b=b, c=c -> trigger does nothing, but content of
> > a and b dont change either although touched
>
> > IF OLD.b=NEW.b wil
Hi,
can any one help me converting longitudes and latitudes
to something that packages like postgis can readily
accept.
calle.com provides longitude and latitude info
of almost all the places in world. fetching that data
and inserting in database is not a problem.
I am wanting to make an appl
