On Wednesday 26 January 2005 20:01, you wrote:
> "Vladimir S. Petukhov" <[EMAIL PROTECTED]> writes:
> > pg_controldata /var/pgsql/data
> > ...
> > LC_COLLATE: ru_RU
> > LC_CTYPE: ru_RU
> >
>
recognize upper/lower case..
SELECT ... ORDER BY do something like that (in English Alphabet):
a
a
Tast12
tes
test
Test12
test12
?:(
On Wednesday 26 January 2005 10:15, Dawid Kuroczko wrote:
> On Wed, 26 Jan 2005 12:01:49 +0000, Vladimir S. Petukhov
>
> <[EMAIL PROTECTED]> wr
Hi!
Sorry for my English..
I want to do case-insensitivity search, like this
... WHERE lower (column_name) LIKE lower (%value%);
This work fine for English..
But i need search for Russian words, lower() operator does not work with
Russian (non-English) chars, but ORDER works fine...
Sorry, of course... :)
On Thursday 20 January 2005 03:15, Vladimir S. Petukhov wrote:
> select * from nets;
>
> name | note | net
> --+--+---
>
> | | 172.16.0.0/16
>
> (1 row)
>
> select * from nets where net >>=
select * from nets;
name | note | net
--+--+---
| | 172.16.0.0/16
(1 row)
select * from nets where net >>= '172.16.4.0/8';
name | note | net
--+--+-
(0 rows)
??
---(end of broadcast)---
TIP 1:
Hi!
Sorry for my English..
I want to dinamcly change type of column. If possible, of course.
Trivial idia - create new temporary column, try to write value from old columt
to temporarity (if type conersion ok - this made using select/update command
and type conversion checks on client's side),
ACUUM FULL after doing your INSERTs (not after each one, of course --
> after doing all of the INSERTs, or after doing a big chunk of them. If
> data is inserted incrementally over a period of time, then just do the
> VACUUM ANALYZE every so often during that time, and you shouldn't have
On Tuesday 21 December 2004 22:00, Bruno Wolff III wrote:
> On Wed, Dec 22, 2004 at 00:16:06 +,
>
> "Vladimir S. Petukhov" <[EMAIL PROTECTED]> wrote:
> > On Tuesday 21 December 2004 21:21, Bruno Wolff III wrote:
> > > On Tue, Dec 21, 2004 at 2
On Tuesday 21 December 2004 21:21, Bruno Wolff III wrote:
> On Tue, Dec 21, 2004 at 20:47:31 +,
>
> "Vladimir S. Petukhov" <[EMAIL PROTECTED]> wrote:
> > Ok, this is a real example:
> >
> > CREATE TABLE account (
> > val1
14:38, Bruno Wolff III wrote:
> On Mon, Dec 20, 2004 at 12:13:31 +,
>
> "Vladimir S. Petukhov" <[EMAIL PROTECTED]> wrote:
> > Hi
> > Sorry for my English..
> >
> > I need to organize database structure for saving statistic data for
> >
Hi
Sorry for my English..
I need to organize database structure for saving statistic data for objects. I
have about 24 * 31 * 4 fields (4 month, 31 days, 24 hours) of data for one
object. Each field contain 8 numbers (N in general). So:
object1 -> data -> field1, field2,...
object2 -> data ->
11 matches
Mail list logo
