65279 Invisible ASCII Character

[ramsiddu007]

Hi all,
  Today i got one problem what i have saved more that one procedures in
a folder. After i have concatenate those files into single file through
shell script. After am trying to run that single file in my server, it was
showing syntax error. If i remove first character it's run. That first
character is invisible, I have checked that *ascii* value, it is *65279*.
How can i overcome this problem. I want to run my single file without this
error.

By below command i am concatenating individual scripting files to single.
*:> cat *.* > .sql*

select ascii('');

select chr(65279);

select length('');

Plz. give me suggestions, it's blocker to my work.


Thanking you,

-- 
*Best Regards:*
Ramanna Gunde

Function Overloading

[ramsiddu007]

Hi Professionals,
I hope you are all doing good. Actually I got one problem. I
have 2 functions like below. Those are having 11 and 14 parameters with
commonly last parameter is variadic array type.

func_get_item_list_phy_param(smallint, numeric, numeric, character varying,
character varying, character varying, numeric, character varying, integer,
integer, character varying[]);

func_get_item_list_phy_param(smallint, numeric, numeric, character varying,
character varying, character varying, numeric, character varying, integer,
integer, character varying, character varying, character varying, character
varying[]);

Now I have called 14 parameters function like
select * from
epps.func_get_item_list_phy_param('1'::smallint,'1.0'::numeric,'1550.0'::numeric,'HR
HOT'::varchar,NULL::varchar,NULL::varchar,'1400.0'::numeric,'192.168.1.29'::varchar,'32272'::int,'119'::int,'c'::varchar,'b'::varchar,'a'::varchar,
null)  as result

After that it was showing following error:

*HINT:  Could not choose a best candidate function. You might need to add
explicit type casts.*

After that I have removed variadic input parameter at last then again run.
But it's calling 11 parameter procedure.

select * from
epps.func_get_item_list_phy_param('1'::smallint,'1.0'::numeric,'1550.0'::numeric,'HR
HOT'::varchar,NULL::varchar,NULL::varchar,'1400.0'::numeric,'192.168.1.29'::varchar,'32272'::int,'119'::int,'c'::varchar,'b'::varchar,'a'::varchar)
as result


Plz give me clarity of actual issue in these cases.

I hope, I'll get some response from you.

Thanks in advance.
-- 
*Best Regards:*
Ramanna Gunde

Re: New committers announced at PGCon 2018

[ramsiddu007]

Great honour. Congratulations to all.

On Sat, 2 Jun 2018, 02:35 Tom Lane,  wrote:

> The core team is pleased to announce the appointment of seven
> new Postgres committers:
>
> Etsuro Fujita
> Peter Geoghegan
> Amit Kapila
> Alexander Korotkov
> Thomas Munro
> Michael Paquier
> Tomas Vondra
>
> Congratulations to all!
>
> regards, tom lane
>
>