On Tue, Oct 15, 2019 at 8:25 AM Geoff Winkless <pgsqlad...@geoff.dj> wrote:
> On Tue, 15 Oct 2019 at 14:35, Ray O'Donnell <r...@rodonnell.ie> wrote: > > > > On 15/10/2019 14:28, stan wrote: > > > I used to be able to return a constant value in a SELECT statement in > > > ORACLE. I need to populate a table for testing, and I was going to do > so > > > like this: > > > > > > SELECT > > > employee.id , > > > project.proj_no , > > > work_type.type , > > > 'rate' 1 > > > FROM employee > > > CROSS JOIN project > > > CROSS JOIN work_type; > > > > > > This statement works correctly, till I add the last " 'rate' 1 line, > then it > > > returns a syntax error. > I would assume you have the value and the alias backwards and you want SELECT 1 AS "rate" Both the double quotes around the alias and the AS keyword are optional.