[GENERAL] decimal_part() function

Hi all, I'm looking for a function similar to dtrunc() to return the decimal part of a float. dtrunc(12.34) returns 12, I need something that returns 34 Does anyone knows how to do this thing? Thanks -Jose'-

Re[2]: [GENERAL] Generic search

Hello Taral, venerdì, 4 dicembre 98, you wrote: >>hygea=> explain select * from comuni where nome = 'A%'; >>NOTICE: QUERY PLAN: >>Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84) >>^ T> The question was about LIKE, not =. Because LIKE uses regexp-style matching and T

[GENERAL] Re:

Hello Doug, lunedì, 26 ottobre 98, you wrote: DS> Does anybody know if 'LEFT','RIGHT','SUBSTR' are working with psql, DS> I keep getting the magical parse error at or near 'left'. DS> Thanks There's the SQL92 substring function: SUBSTRING(string [FROM start] [FOR chars]) Jose'

Re: [GENERAL] aggregate question

Hello Ulf, mercoledì, 21 ottobre 98, you wrote: UM> I posted the questions below a few days ago to the SQL list, but UM> apparently there is nobody there who can help -- maybe I'm luckier in UM> this list? :-) UM> -- UM> I'm a

Re: [GENERAL] pg_dump

Hello System, venerdì, 18 settembre 98, you wrote: SA> Hi all. I am using posgresql-6.3.2 . SA> I have the next problem : it seems that pg_dump doesn't dump views ... SA> I'm using : pg_dump -D -z -f main.dump main SA> to dump my database main . SA> How can I see views in my dumps ? SA> Is th

[GENERAL] DELETE statement KILL backend

Hello all, I have a strange problem that I can't understand. I have been my PostgreSQL-6.3.2 on Linux-ELF-2.0.34 working without any problem for many months. This morning I can't DELETE anymore. If I try to delete a row from any table I have this message: PGexec() -- Request has sent to

Re: [GENERAL] simple auto increment question.

Hello Jeremy, giovedì, 20 agosto 98, you wrote: JH> I want to create a simple auto increment field JH> starting at for example. I supose you mean 1 JH> How do I do this in postgres? JH> Thanks JH> -jeremy Examples: -- How to create a sequence starting with 1:

Re: [GENERAL] CREATE TABLE ... CONSTRAINT

Hello Dario, lunedì, 17 agosto 98, you wrote: DB> Hi all DB> I have been using postgreSQL for a while now and it is doing the job DB> I want it to. Thank you to all pgsql-hackers for their good job. DB> Iam runninga vanilla 6.3.2 installedfrom DB> postgresql-{

Re: [GENERAL] What to do with no foreign keys

Hello Brian, giovedì, 9 luglio 98, you wrote: B> If I have two tables, which are like this: B> baseball_team B> - B> team_name B> number_of_players B> games_played B> total_runs B> baseball_game B> - B> home_team_name B> visitor_team_name B> home_runs B> visitor_runs

Re[2]: [GENERAL] COALESCE() or NVL()

Hello Robin, giovedì, 18 giugno 98, you wrote: RT> At 12:03 PM 6/17/98 +, Jose' Soares Da Silva wrote: >>> Jose' Soares Da Silva writes: >>> > SELECT name,NVL(salary)+100 AS dream FROM emp; >>> > name |dream >>> > ---+- >>> > Sam| 1300 >>> > Claire | 5100 >