Ok, so here's my small knowledge on this matter
select date(date('2001-08-20')+interval('6 months'));
date
2002-02-20
I'm sure there's more elegant and shorter ways of doing this, but a quick
answer, maybe you're stuck somewhere :)
Antti
Tested it on 7.0.2.
On
Hallo.
Maybe its not the right list, but does the Postgres 7.1 support now
unlimited text field? In previous versions it was limited to max 31k, or
even less, depending on the compilation etc.
Greetings,
Antti
---(end of broadcast)---
T
Hallo.
I was just searching documents how to define BLOB in postgres and couldn't
find any hints. Could somebody enlighten me? Postgres is 7.0.3. I need to
insert into DB text field more than 8000 symbols and there is no way, I
can upgrade postgres to 7.1, so only way I see it's possible, is by
d
Hm, about memory exhausting I don't know, but the other day I tested the
limits of the text field in Postgres 6.5.(2 or 3). When ppl inserted text
in windows environment through html forms, then they got no more than
5000+a bit more symbols. Ok, I decided to test and inserted 8000+bit more
from li
I have a table with personal data, including date of birth in date format.
What i need is a select that searches birthdays in certain range.
E.g. I need to find all birthdays starting from 15.april until 20th
december. As you all understand, year doesn't matter :P
Any simple and elegant solutions
Good morning.
Is there some way to make interval query?
Towns table(estonia towns, heh :P)
id | name
1 Elva
2 Tartu
Tallinn
3 Tallinn/Haabersti
4 Tallinn/Mustamae
...
etc.
What I need is when the town's id= I want to make query
where id= OR id=
Good morning.
Since I asked this question before psql question, I would mention other
aspects as well. I had same problem, history not working etc. So I was
told to install readline. I checked, and readline rpm was installed. So
next thing, I was told, was to upgrade my postgres. I checked for up
Morning.
I installed new Mandrake 7.2 and was eager to try new postgres. So I
installed it and used pgsql. What surprised me was that the arrow keys
wouldn't work anymore as history, instead I get those ascii codes.
I was wondering is it the matter of configuration or is it a new feature
that one
On Thu, 9 Nov 2000, Astrid Hexsel wrote:
> Hello all,
>
> I have a form which has got checkboxes and I am having problems to have their
> values stored in different rows of a table.
>
>
> What I have done is:
>
> # colour_id is the name of my checkboxes in the input tag
>
>
> etc ...
Hm, I usually use
pg_dump -f smthng.out dbname -u
after that program asks for username and password,
there were some possibilities within postgres too, but you can find them
yourself. And why not to dump all data as superuser, that way u have no
problems with privileges at all.
Antti
On Tue, 3 Oc
Lo.
I'm in dire need of knowledge, how to extract data by month. Monthday
and year arent' important, those I can't give from perl script, but what
I do give to postgres are the numbers of the months. Date field is in
timestamp. I thought about date_trunc, but I can't think of, how to get
data wi
Is there any possibility to unlock tables after they've been locked? The
manual part of lock was fuzzy, so I ask from experts instead. MySQL
uses lock and unlock.
Antti.
Lo. I have in my local machine quite new POstgresql
[PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66]
but the machine, I am writing scripts for has some ancient postgres(btw,
how to see the version on psql, if its not shown at the start? ).
I made a query
SELECT ajaperiood.isi
I thought, I finished that group by theme.
What i ment was, that I have information about workers, and I have to make
report on them. Report should contain status about workers with the
restriction , that the data is about last day of the month. I use perl as
a scripting language, and how the he
Ok, if I want to get non-aggregat data in groups, I use order by. This
group by seemed so logical though, but the fruit that u can't have, is
usually the most sweet.
New question, how to get the last day of month(order data by last day of
month). And to prevent chain letter from misunderstanding
Ok, if I want to use group by, then I have to put every select field
afterwards to group by. But I do want to group by one field.
Hence
select workgroup,id from job group by workgroup,id;
would create groups of 1?
But I want to group by workgroups.
Sorry if my explanation is fuzzy.
A.
I have table job, and I want to select data from it, grouping by
workgroups. When I use
select id,name from job where workgroup='top leaders' AND ... group by
workgroup;
When I want to group, I get
ERROR: Illegal use of aggregates or non-group column in target list
I'm confused, why does quer
> I think, the following select will solve your problem
>
> select first.id
> from first
> except
> second.id_first
> from second;
>
Nay, I got parse error.
Antti
Greetings.
I have a problem. I have 2 tables. E.g. work and workers. I want to
select records, that 1st table has, and the second hasn't(both have id
attribute). I mean I can't do it with is NULL, because those records don't
exist. I was shown, how it is done with mysql
select first.id,second.id
Lo.
Today I digged in manuals and other docs, but didn't find any hint, how
to get data from table, where some cols are in date or datetime format,
and the data was about last month, or about special month.
Psql help was unhelpful too.
Here's example:
In table workers is data with different date.
20 matches
Mail list logo
