the vector(s) closest in
N-space to the input vector. You might dig up an old 3-variable calculus
book, find the formula, and write a PL/pgSQL function to compute the
distance between two N-dimensional vectors...
Regards,
Ed Loehr
http://www.postgresql.org/docs/postgres/index.html
Regards,
Ed Loehr
Jean-Marc Libs wrote:
>
> I have this table:
>
> CREATE TABLE film (
>film_id serial,
> ...
>
> SELECT setval ('film_film_id_seq', 6);
>
> I have this query in PHP:
> insert into film
>
>(film_country_id,film_country_id2,film_country_id3,film_country_id4,film_prod_year,film_ec_certif,film_
ve looked though the
> documentation and I am still struggling :-(
You probably don't need to increase the buffer. More likely, there is an
unterminated string constant somewhere in db.out. Yes, that would
probably be a bug in pg_dump, but I do vaguely recall problems in 6.5*
with pg_dump. You might search deja for your error message.
Regards,
Ed Loehr
t you're after?
select o.date, sum(d.qty * d.price)
from orderdetail d, orders o
where d.orderid = o.orderid
group by o.date
Regards,
Ed Loehr
hours 32 minutes..
Try to_char(). http://www.postgresql.org/docs/postgres/x2976.htm
Regards,
Ed Loehr
tual day in
> the date field.
>
> Ex.: select * from item where date = '2000-06-%%';
Multiple ways to do it, but here's one:
select *
from item
where date_part('month',mydate) = 6
and date_part('year',mydate) = 2000;
Regards,
Ed Loehr
ven't checked to see if it matters...
Regards,
Ed Loehr
Patrick Kay wrote:
>
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
There are many examples on how to do this in the archives or via
deja.com's power search.
Regards,
Ed Loehr
Chunky wrote:
>
> Could someone please enlightenment me what command in psql i should use
> to show the various triggers and rules that i have created?
These might work...
select tgname from pg_trigger
select rulename from pg_rewrite
Regards,
Ed Loehr
time we perfomed the query.
>
> then
>
> if (&do_check($ptr_array)){
>fetch rows
>store in cache
> }
> -->use the cache
I haven't seen that syntax before with your use of "as", but I get your
gist. Sounds reasonable, though it looks like a major pain, stealing
most of the pleasure and convenience of SQL. I'd almost be tempted to
build a regex'er to pick out the table names from each query in a layer
between DBI and the app until the regex performance became an issue.
Regards,
Ed Loehr
Ed Loehr wrote:
>
> Vincenzo Passoli wrote:
> >
> > i'm developing a framework (mod_perl+apache) that reads the db-schema and
> > explode html forms.
> >
> > now i read the schema and cache it into perl-hashes to speedup things.
> >
> > my pr
7;t understand very well how
these are used. Maybe someone else can say or you can experiment...
Regards,
Ed Loehr
(PS: Posting to only one of -general or -sql will almost always be
sufficient.)
ear if others have a better/faster solution here.
Regards,
Ed Loehr
mikeo wrote:
>
> is there an equivalent to rownum in oracle?
>
> also, where can one find reference to "hidden columns"
> such as OID or, as in oracle, rownum?
oid is the equivalent. not sure documentation exists for these...
Regards,
Ed Loehr
What is the definition of the table 'some_table'??
Regards,
Ed Loehr
Rick Parker wrote:
>
> Does anyone know why when I am in a particular DB as user postgres and use
> the following statement, why I get this error?"
>
> This is the statement;
> SEL
not? The query string is created before prepare is called...
Regards,
Ed Loehr
ried to do -> finish and -> commit after each
> query, but the messages still appear.
>
> Any hints?
I think that happens if the backend aborted (elogged) with an ERROR
message and you did not start a new transaction. ERROR kills the current
transaction altogether in 6.5.*, IIRC.
Regards,
Ed Loehr
18 matches
Mail list logo
