Course Solutions Uncategorized (Solved) : Correct Query Create Replace Function Employeeafter1968 Returns Bigint Date Declare Birthd Q34414558 . . . .

(Solved) : Correct Query Create Replace Function Employeeafter1968 Returns Bigint Date Declare Birthd Q34414558 . . . .

 

Correct the query

Message SQL Error [42702]: ERROR: column reference birthdate A is ambiguous Detail: It could refer to either a PL/pgSQL variable or a table column.1 Where: PL/pgSQL function employee_after_19680 line 4 at SQL statement

CREATE OR REPLACE FUNCTION EMPLOYEE_AFTER_1968()
returns bigint as $date$
declare birthdate bigint;
BEGIN
SELECT birthdate FROM EMPLOYEE WHERE
BIRTHDATE >= DATE(‘1968-01-01′, ’00:00:00’);
return date;
END;
$date$ language plpgsql

Message SQL Error [42702]: ERROR: column reference “birthdate” A is ambiguous Detail: It could refer to either a PL/pgSQL variable or a table column.1 Where: PL/pgSQL function employee_after_19680 line 4 at SQL statement Show transcribed image text

Expert Answer


An answer will

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

(Solved) : 4 25 Marks Want Create Class Called Course Represents Course Offered Ece Course Defined Fo Q32729345 . . . .(Solved) : 4 25 Marks Want Create Class Called Course Represents Course Offered Ece Course Defined Fo Q32729345 . . . .

<br/><img src="../../../media.cheggcdn.com/media/e2b/e2bacc72-4b9a-4fbc-88a7-2291e32e1211/image.png" alt="4. (25 marks) We want to create a class called Course, which represents the course offered at ECE. A course is defined with the following attributes: code (string),

Manager Crew Installs Carpeting Tracked Crew S Output Past Several Weeks Obtaining Figures Q34298656Manager Crew Installs Carpeting Tracked Crew S Output Past Several Weeks Obtaining Figures Q34298656

<p>The manager of a crew that installs carpeting has tracked thecrew’s output over the past several weeks, obtaining thesefigures:</p>WeekCrew SizeYards Installed13103227234102455856726753<p>    <br/><strong>a.</strong> Compute the labor productivity for each of theweeks. <strong>(Round