Tag Info

New answers tagged

1

What you see is obviously a display bug in the current pgAdmin 1.20. I could reproduce it. You must be aware that the code you see is re-engineered from system table entries. If you look up your function in the system catalogs directly, you'll find that your the return type has been registered properly (at least it works for me in pg 9.4): SELECT ...


0

In don't think you can use the resullt of a function. The documentation for the loader can be found in the Utilities Manual. Applying SQL Operators to Fields says The execution of SQL strings is not considered to be part of field setting. Rather, when the SQL string is executed it uses the result of any field setting (...) Field setting means that the ...


2

If I'm understanding you correctly what you're looking to do should be quite simple. I'm not entirely sure how you're setting @date1 but for this to work you will need to set that as a SSIS variable and for this example I'll assum it's a date. Then you need to create your query as a variable and then set it as an expression like so. Then you set your ...


2

It's not possible to bind column names to variables, but you can achieve similar results by using dynamic SQL. DECLARE @datetxt varchar(10) = '2015-01-01' DECLARE @sqltxt nvarchar(1000); SET @sqltxt = N'SELECT dateAdd(second, 1, ' + @datetxt + ') AS StartTime FROM Termination_Call_Detail' Exec (@sqltxt)



Top 50 recent answers are included