On Mon, Apr 21, 2014 at 8:29 AM, Richard Hipp wrote:
> On Mon, Apr 21, 2014 at 1:16 AM, Andre wrote:
>
> > Hi,
> >
> > Apparently when a CTE is used, the column name includes the table alias.
> > However, when no CTE is used, the alias is not present in the returned
> > column name.
> >
> > SQLi
On Mon, Apr 21, 2014 at 1:16 AM, Andre wrote:
> Hi,
>
> Apparently when a CTE is used, the column name includes the table alias.
> However, when no CTE is used, the alias is not present in the returned
> column name.
>
> SQLite version 3.8.4.3 2014-04-03 16:53:12
> Enter ".help" for usage hints.
On 21 Apr 2014, at 6:16am, Andre wrote:
> Apparently when a CTE is used, the column name includes the table alias.
> However, when no CTE is used, the alias is not present in the returned
> column name.
SQLite has no standards at all about column names unless you specifically set a
column name
Hi,
Apparently when a CTE is used, the column name includes the table alias.
However, when no CTE is used, the alias is not present in the returned
column name.
SQLite version 3.8.4.3 2014-04-03 16:53:12
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENA
4 matches
Mail list logo