Josh Berkus wrote:
> Greg,
>
> > Anyone have a good pre-built user-defined type definition for creating /
> > maintaining / manipulating a SSN ... where valid chars are in the range
> > 000-00- through 999-99-.
>
> Actually, the range is more narrowly defined than that. I'm not sure of t
Thanks for the clarification Tom.
I have one more query.
Is there a way to get the error number for the last Transact-SQL
statement executed in a Function in postgresql?
In MSSQL Stored Procedures we used @@ERROR variable to get the same. Is
there an equivalent in postgresql functions?
Regards,
I had the following code in an MSSQL Stored Procedure:
SET @QueryToPopulateTemp= "INSERT INTO
#Tmp_Conference(ConferenceType, CallManagerId, ClusterId,
DestConversationId, ConnectDate, FinalDestination)"
+" SELECT 1, Global_CallId_CallManagerId,
globalCallId_Cluster
The following Query string , when executed does not give an Error, even
though the table Tbl_Billing_Data is not present.
QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType,
CallManagerId, ClusterId, DestConversationId, ConnectDate,
FinalDestination)''+'' SELECT 2, Global_CallId_Ca
I had the following code in my MSSQL Stored Procedure:
--Adding 23Hrs 59Mins 59Secs to the ToDate(@ld_ToDate is
DateTime datatype)
SET @ld_ToDate = DATEADD(ss, 86399, @ld_ToDate);
I have changed it to the following for Postgres Function:
--Adding 23Hrs 59Mins 59Secs to t
George A.J wrote:
> Hi all,
>
> We are providing database solutions in postgreSQL...
> Now using PostgreSQL 7.3. It is performing well.
> But Now we have some enterprice level requirements.
> One of Our requirement is to provide a distributed solution in PostgreSQL.
> The questions are...
> 1. I
