Hi,
You can use to_hex() function to convert integer to hexa number. I have tried
with a small example.
create table testing( id int4 , sHex varchar( 20 ) )
insert into testing( id ) values( 204678 );
insert into testing( id ) values( 2076876 );
update testing set sHex = ( cast( to_hex( id
I have read the great work that all the list members have done working
with cross tabs (pivot tables) in postgresql. The issue I have not seen
a solution for, but would really like to see, is the ability to return
the results of a dynamic (variable # of columns) cross tab function as a
recordset.
Hi
Is it possible to refer to a unique row identifier on a view ?
I have the following view but in a subsequent select I need to refer to
each row's unique identifier and I know oid's are not valid for a view.
create view persontransit
as
select personid, planet, name as aspectname, position a
Hi,
I am not able to understand "Returning only one row", since 'aaa' having 2
rows and 'bbb' having 3 rows and what criteria single row should be returned.
Please let me know the expected result and I will try to find out a solution
for it.
for set returning function the following link ma
I'm looking for a way to use a parameter given to a trigger function as fieldname. It should be something like
create function f_makeupper() returns trigger as '
begin
NEW.TG_ARGV[0] := upper(NEW.TG_ARGV[0]);
RETURN NEW;
end;
' language 'plpgsql';
create trigger "TRIG_tbltest" before inse
Hello,
I have the following problem :
I have a table like
IdNum Date AValue
1 10 01/01/2005 50
2 10 31/05/2005 60
3 25 02/02/2005 55
4 25 15/03/2005 43
5 25 28/05/2005 62
etc.
Hi
It is not advisable to add a variable length data field in the Index key, since
it is very difficult predict the size of the field which may vary from record to
record.
are you included this field for Full text search on data
field?
Regards,
R.
On Thu, Jan 01, 2004 at 03:13:48PM +0530, Dinesh Pandey wrote:
> One of the columns in primary key is of type "TEXT". I am able to insert
> with small data, but for around 3000 characters it's failing. How to handle
> that?
Easy, btree indexes can't handle data with more that 2713 bytes.
You need
Hi,
The issue looks like your Index width exceeds the maximum width
of the index key limit,
Please review the keys used in the index.
Regards,
R.Muralidharan
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On
Behalf Of Din
On Thu, Jun 02, 2005 at 01:57:26PM +0200, Bart Degryse wrote:
>
> I'm looking for a way to use a parameter given to a trigger function as
> fieldname. It should be something like
> create function f_makeupper() returns trigger as '
> begin
> NEW.TG_ARGV[0] := upper(NEW.TG_ARGV[0]);
> RETURN
10 matches
Mail list logo
